General discussion


linking ms excel 2003 to ms access 2003

By sezua2000 ·

I have office 2003, and i have develop a database from ms access 2003.
What i want is to link ms excel and ms access so as when am updating either of them both will be updated

The aim is to have ability to produce charts from ms excel and to produce report from ms access.

Is there anyone can advice me how to do this (link)

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Query from Excel

by John_okeefe_2001 In reply to linking ms excel 2003 to ...

Hi !
You can use this product to query Access from Excel. It is a freeware add-in for excel.

It can help you check the data easily.

Good luck on that. Thanks. J

Collapse -

SQL Query from Excel

by sezua2000 In reply to SQL Query from Excel
Collapse -

Why not just use a Linked Table?

by Blackbird "BB" In reply to linking ms excel 2003 to ...

If I were you I would use the import external data
tool in Excel to copy the table into a worksheet.

then link to that table in the Access Tables space.

Right Click Link Table,
and now link to the table you just created.
you now have a table that is dynamically linked between the two;

You will have to point any pre-existing Queries to the new table, or rename it after the original; but I think this is your simplest solution. BB.

Related Discussions

Related Forums