Create data loader in Visual Studio 2010 to load excel spreadsheet in to SQL.

Is there an easy way to create an excel spreadsheet importer to load data into a sql database in visual studio 2010?
ogmike2000Asked:
Who is Participating?
 
reitzenConnect With a Mentor Commented:
I've always had good luck keeping it simple and importing directly using T-SQL
SELECT * INTO tblXLImport FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')

Open in new window

0
 
ogmike2000Author Commented:
Thanks, worked great!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.