Linking Access queries to several worksheets

[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

 

[John Nurick]

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.

 

[Glenn]

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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.