excel data into SQL Server 2012 Express for
User only i am getting the error. The Error is as mention below
Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'User'.
And the my import statement TSQL code is as follows:
Use DB1; Go select * INTO User from openrowset('MICROSOFT.ACE.OLEDB.12.0', 'Excel 12.0; Database=C:\DBTableDataRecords\User.xlsx; HDR=yes; IMEX=1', 'select * from [User$]'); Go
NB: From the above TSQL code i am able to import excel data for creation of other tablename (Except User table name). Even I have check the
MICROSOFT.ACE.OLEDB.12.0 provider link server object. Where provider option of
'Allow inprocess' is enable.