Use Excel Spreadsheet to Update Access

[Tina]

Is there a way that I can have the information that is
entered into an Excel Spreadsheet automatically update the
fields in the Access Database?

I have an access database where I created a query to pull
down information into a spreadsheet for people to update.
Then I have to put that data back in the database. The
query is taken from several tables.

Please HELP!

 

[Peter Atherton]

Tina

You should be able to do it by hand. If the records are
new update the spreadsheet then copy the data. Swith the
Access and open the query and choose Edit, Paste Append.
The data will be added to the relevent tables called by
the query.

If the updating is performing calculations on each record
then perhaps the query could be altered to do this. Access
can perform calculations in forms and queries.

If niether is possible would should alter the data in the
Access query because, as said in the first paragraph,
altering the query will update all the relevent tables.

If this is not want you need try posting again in the
dedicated forum for Access - they will be more knowlegable
there.

Regards
Peter

-----Original Message-----
Is there a way that I can have the information that is
entered into an Excel Spreadsheet automatically update

the fields in the Access Database?