Linking Excel & Access

K

K-Gr0428

I have an Excel spreadsheet, complete with pivot tables and graphs, which is
linked to the data in an Access database (specifically to a query). This
spreadsheet updates just as it should to the data.

My question is, now that I have that all working, how can I get a command
button on my switchboard in Access connected to this spreadsheet so that it
opens from within my Access database?

Thanks for any help you can give to this Access student!!!
 
A

Arvin Meyer [MVP]

Barry McConomy said:
Hi

I would like to have an Excel spread sheet (Pivot Table) to link to an
Access database query.

Can you tell me how to do this.
Click to expand...

Usually, starting a new thread for a new question gets a better (and faster)
chance of response.

That said your question has an easy answer. I'll have to assume that the
Pivot Table has well formed output that can be easily read. Link it as a
table by choosing File ... Get External Data, either import or link the
source, choose the source type with "Files of Type", then choose the file.

Once that is done, you simply use the table in a join in your query, just
like any other table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top