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 - 2004-09-03 : 08:35:33
|
| Priscilla writes "HiHow to select a Linked Excel table in SQL PASS-THROUGH QUERY in Access?Thanks" |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-09-03 : 08:46:10
|
| I recommend that you don't use pass-through queries to access Excel tables; use a linked table. if you need to use a pass-through query, all you need to do is create a new query, set it to "pass through", specify the full ODBC connect string to the Excel file in the properties, and then enter the SQL statement (pure text - no QBE grid) to select what you need.- Jeff |
 |
|
|
|
|
|
Selecting table in SQL pass through