We help IT Professionals succeed at work.

Bulk insert a excel file

IT-CICA
IT-CICA asked
on
I want to Bulk insert an excel file into a SQL table. Can I use the Bulk insert command for it?

When I tried 'Bulk Insert', I got a truncation error message (the size of the column in table is nvarchar(50) and the field length from the file is not greater than 50.

Thanks
Comment
Watch Question

why don't you use OPENROWSET or LinkedServer?

Author

Commented:
OPENROWSET (with jet oledb 4.0 provider) is giving an error  - JET OLEDB is not registered
in that case download it and install.... it is much much easier to use OPENROWSET
Top Expert 2010

Commented:
Just use Import/Export wizard of SQL server and your done, or if you want to repeat you can save your package and recall it