Linked Excel Spreadsheet not updating in Access97...

I've posted this a couple other places with no luck. Thought I'd try here too.

I have an Access97 Database that is made up of a linked spreadsheet and a form built from it. If a user makes changes to the spreadsheet, saves it, and then opens the database, the changes are incorporated into the form. However, if they open the database and use the form to add a new record, it doesn't carry down to the Excel spreadsheet. That record appears in the form from that time on and the # of records is increased in the form, but isn't duplicated to the spreadsheet.

Anyone know what I'm missing here to make this a two-way communication instead of a one way?

Thanks,

Galdor

 

Hi Galdor, Have I understood correctly ?
You have an .mdb Access file. Data in this file comes from a linked
MS Excel file .xls using "get External data" Then you added a Form to the
.mdb application. From new entries on the form, no new data appears in
th .xls file.
Q? : On the .xls do you use a different range of cells for the transfer to .mdb
to the cells that transfer .mdb to .xls ?
regards

 

Almost correct....

I have an access97 .mdb file. The table in the database is actually a linked table from an excel (.xls) file. This is done using the tools\addins\linked table manager in access.

I then have created a form in access and hooked the fields in the form to the linked table so that the data in the form is pulled from the excel file.

My problem is that new records added to the .xls file carry to the access form, but new records added by the access form don't carry down to the excel table.

Thanks for any help you can give...