Linking Tables within Access to a linked Excel table

[leamas]

I'm trying to use a template to track assets-specifically this template:



http://office.microsoft.com/en-us/te...001018459.aspx

Is there a way I can link an excel doc to my database that provides all of my data, that is thereby linked to other tables within Access?

Please let me know if I should rephrase my question.

I want my data to be updated as it is manipulated within the independent excel doc when I open access.

Thank you in advance for your help!!

[June7]

The linked Excel and tables can be joined in queries but changing data in the tables would require running UPDATE and/or INSERT sql actions.

[leamas]

Or perhaps I don't need a linked table, just import data to excel. Please help!

[June7]

I am now confused. You want to update the Excel or the Access tables? Which way is the data flowing?

Excel can link to Access table or Access can link to Excel sheet.

[leamas]

Basically, I'm trying to fill the template with my data. Ideally, I would like the data to be automatically updated as it is changed in the original and independent excel document. I understand this may be difficult, so simply importing my data to the template would be sufficient.

I am very new to Access. The template offers everything I need such as asset categories, departments, maintenance and status. I simply have to much data to manually input. I understand I will need to change the forms to accomodate my needs but I would like to have the database filled with my data.
Data will be flowing into Access from Excel, but like I said before, this is not a requirement.

Thank you for your help!

[June7]

You want to do a one-time import of data from Excel into Access database?

If not too much data, simple copy/paste of records might get you through the transition.

Otherwise, if the sheet structure is simple enough, try setting links to the Excel sheets then run INSERT SELECT query to populate the tables with the linked sheets as the data source. Review: http://www.sqlteam.com/article/using...insert-records

If linking fails, will require VBA code to pull data from the Excel into tables.

[leamas]

Thank you, your help is very appreciated!!