Free Webmaster Tools, Resources, Articles
 
 

Excel to MS SQL  

Written by izzet soy from Congrenic on 27 May 2009

INSERT INTO [DatabaseName].[dbo].[TableName] ( [Field1] ,[Field2] ,[Field3] ) SELECT * from OPENROWSET('Microsoft.Jet.OLEDB.4.0' ,'Excel 8.0;Database=c:Book2.xls' ,'SELECT * FROM [Sheet1$]')



Become a Member
Become a member and create your profile.

Then you can;
  • Get quality backlinks
  • Add resources & articles
  • Use tools in your website
  • Get displayed on homepage of VENOU
   

Subscribe to Venou
Enter your email address:
 

             
 Subscribe in a reader

Search



 
  © Copyright 2009 Venou | Contact | Partners: webmaster tools  buy windows 7