LINKING EXCEL FILES

[JL_CAD]

I currently have a few Excel files that contain duplicate data. I would like to make a database in Access where the fields used in more than one sheet is updated in all sheets. I would like to link the files rather than importing them into Access because I am working with users over a network that might not have Access available to them. I need to know if there is a good way to accomplish this. Thanks

 

[Corticus]

Are you saying you want to be able to update several Excel worksheets with the information from one Access database?

If so, that shouldn't be too hard, I would use Data|Get External Data|New Database Query, and for each sheet, use MSQuery to query from the database. Each query can have its own set of fields, so you can have the same field on several sheets, without having enter redundant data.

When you enter the populated data set, if you click on the little explamation point, Excel will refresh the data from Access.

If I'm way off, post back with more specific information and we'll see what we can do...

HTH,

 

[JL_CAD]

Can I link all my tables together in a blank database, or do I have to have an existing?

 

[Corticus]

Are you saying you want one Access db to combine data from several worksheets, if so, yes. Use File|Get External Data and either 'link tables' to have your table's data updated reguraly, or import tables for just retrieving data.
The data will be retrieved into Access in the form of linked tables and queries, and your data will remain in Excel.

HTH,