-
About OpenRowSet()
Oscar
See if you find the file using master.dbo.xp_cmdshell 'dir C:\ExcelFile.xls'
If the Sql Server find the file so, open the file in Excel and see the name of Sheet.
Wrote in your query analyser the script below:
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:\ExcelFile.xls";
Extended properties=Excel 8.0')...Plan1$
--My Excel file name ExcelFile.xls and the name of the sheet is Plan1
If your have the message about permission, see the KB below
http://support.microsoft.com/kb/327489
bye
Fernando
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|