Read Time37 Second
/*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.

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Close