Link From Access To Excel

[Guest]

I'm quite familiar with having an Excel worksheet linked into Access.
However, I have a coworker asking me about having a reverse link - where an
Access table (or query) is linked to an Excel worksheet, and any updates to
the table are reflected in Excel.

I've never done something like that before. Is it possible? And if so, what
happens if new columns are added to the underlying Access table?

Does the answer change if the "table" being linked from Access is actually a
query or an ODBC-linked table from SQL Server?

Thx.

 

[Sylvain Lafontaine]

http://support.microsoft.com/kb/904953

 

[Guest]

I'm not aware of any way to "link" Access to Excel, but I do have a database
that I developed that exports an Excel spreadsheet to the C drive whenever
the database is updated, overwritting the previous Excel file. I wrote a
Macro to do that.

 

[Guest]

Hi

If I understand which way you are linking you want to be able to go into
Excel and get Excel to look at an access database.

Try...

In Excel choose Data
then Get External Data
New Database Query
Choose type - Access Database
Browse to the database file
....follow prompts...
Store data in Excel

You can right click the data in excel and choose refresh data to see any
changes that have been made in access (and can set timed refreshes)

If a new column is added, it won't automatically show in Excel - you would
have to right click the data in excel and edit the excel query

hth

Andy Hull