Linking Access queries to several worksheets

  • Thread starter Thread starter Glenn Fisher
  • Start date Start date
G

Glenn Fisher

Can someone tells me what is the code to link 3 Excel
worksheets in a workbook to 3 Access queries.
Thanks a million
 
Hi Glenn,

I can't decide whether you're trying to make Access data available in
Excel or vice versa. If the former, look up Excel's QueryTable Object.
If the latter, it's usually simplest to manually create linked tables
(linked to the Excel sheets) and then base the queries on these.
 
Thanks for your help. You're right that it's easier to
manually link the Excel worksheets to Access.
-----Original Message-----
Hi Glenn,

I can't decide whether you're trying to make Access data available in
Excel or vice versa. If the former, look up Excel's QueryTable Object.
If the latter, it's usually simplest to manually create linked tables
(linked to the Excel sheets) and then base the queries on these.
Can someone tells me what is the code to link 3 Excel
worksheets in a workbook to 3 Access queries.
Thanks a million
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Back
Top