access / excel link

[tom]

i know that i can link excel tables to an access database. can i link an
access table to a spreadsheet?

 

[Stefan Hoffmann]

hi Tom,

i know that i can link excel tables to an access database. can i link an
access table to a spreadsheet?

You may use Data/Get External Data, but this not the same as linked table.

Depending on your needs, you may consider using a VBA procedure (macro)
to read the data with a DAO.Recordset and copy it manually into to your
cells - you can copy also a complete recordset, see CopyFromRecordset in
Excel.


mfG
--> stefan <--

 

[tom]

thanks stefan,

i'm afraid it's all a bit complicated for me!! my intention was to use a
spreadsheet whose data would update automatically from an access table. i've
looked at other threads and it looks as though this is not achievable.
thanks again for your help.

 

[Jeanette Cunningham]

tom,
if you are entering data in the database, you can show the updated data in
excel.
If you and your users are all on the same network, you can link the
spreadsheet starting at the Excel end.
First of pull out the data you want to see in excel and save it in a query
in the database.
Open excel | Data | Import external data | Import data
In the dialog that opens, navigate to the saved query in the access
database. Follow the prompts as excel guides you through the process.
The end result is a spreadsheet with all the data from the query.
Next time you open the spreadsheet, you can use the External data toolbar to
refresh the spreadsheet - this will update your spreadsheet with the latest
data in the query in the database.

Jeanette Cunningham

 

[Duke Carey]

Nick Hodge, an Excel MVP, has an excellent explanation of how to do this on
his website. Be sure to read all the way to the bottom of the page. That is
where he discusses Access specifically


http://www.nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm