• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 552
  • Last Modified:

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?
0
ogmike2000
Asked:
ogmike2000
1 Solution
 
reitzenCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now