Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-09 : 00:49:54
|
| Ann writes "Hi,I have created a linked server for an Excel worksheet asEXEC sp_addlinkedserver 'ExcelSource', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:\aflavin\ExcelFies\SampleDatabase.xls', NULL, 'Excel 5.0'GOI now need to write a Stored Procedure that pulls all the data in the excel file. I am trying to use OPENQUERY but don't know how to write the query. What do I use in the FROM part of the query?SELECT *FROM OPENQUERY(ExcelSource, 'SELECT * ?????') Thanks in advance,Ann" |
|
|
|
|
|
Using OPENQUERY with LinkedServer (Excel)