Help with Linking Excel to acees

[xxThreelionsxx]

Is was wondering if there is a way to get Excel to link straight into a access table and return certain records based on a field being empty or not and also once this recorded has been Viewed in excel is there a way to write back any changes made in excel to the access table

Hope this makes sense

thanks

 

[bubba100]

To look at the data in Excel that is contained in an Access db try using MSQuery.

 

[MajP]

This sounds all pretty basic and you could google this for plenty of examples. The question is where do you want to do the work, in Excel or in Access?
You can link to an Excel table from access or you can import the table into Access.
What version of Access do you have? The features are slightly different with what you can do.

 

[xxThreelionsxx]

Thank you for the replies

I was looking at updating the table using excel 2003

 

[MajP]

If you link to the excel table then any changes in the spread sheet is seen in the database. In this method there is really no Access table, you are just seeing the excel data in access and you can use the excel data in forms, reports, and queries as if it was in Access. You just cannot modify the linked data in Access. Is there information in the Excel table that needs to persist in the Database? If not then a simple link is fine. However you can use the data in the linked table to run an update query on another table.

If you import the table that just creates an Access table in the database and there is no longer any linkage to Excel.