Import Excel data into SQL Server 2005 table using distributed queries
/*SQL server configuration settings */
exec sp_configure
sp_configure ’show advanced options’, 1
reconfigure
exec sp_configure ‘Ad Hoc Distributed Queries’, 1
reconfigure
/*Excel import into sql table using distributed query*/
select * into XLimport from
openrowset(‘Microsoft.Jet.OLEDB.4.0′,
‘Excel 8.0;Database=C:\Documents and Settings\Administrator\Desktop\filename.xls’
,[Sheet1$])
select * from XLimport
NOTE :
If you are in need of any Web Development feel free to Inquire us . Dhanashree Inc. Expertise in Asp.net Development, Php Development, Website designing, Open Source customisation. Dhanashree Inc can be our offshore development company / outsourcing web development company, hire dedicated web programmers.
Above information is for knowledge sharing if you have problem / issue / suggestion please intimate us with details for proper and prompt action.
2 Comments