Hi all!
I have recently set up a database. Each week, data gets imported into the database from an excel spreadsheet. (update and append)
When I first setup the DB, let's say it had 10 field names. These 10 field names were automatically imported and setup from an initial excel
spreadsheet. Afterwards, I added approximately 10 field names manually, and saved.
Then say I create a query and export the data with ALL the fields into an excel spreadsheet. I then edit one row of this excel spreadsheet. I update each field including the original ones, and the manually added ones. Then I run my update/append queries from within access to import this data back into access.
The problem is this: the edited data in the "original" fields updates OK, but the edited data from the "manually entered" fields do not update at all!
How can this be possible? Any help would be appreciated.
Alex~
I have recently set up a database. Each week, data gets imported into the database from an excel spreadsheet. (update and append)
When I first setup the DB, let's say it had 10 field names. These 10 field names were automatically imported and setup from an initial excel
spreadsheet. Afterwards, I added approximately 10 field names manually, and saved.
Then say I create a query and export the data with ALL the fields into an excel spreadsheet. I then edit one row of this excel spreadsheet. I update each field including the original ones, and the manually added ones. Then I run my update/append queries from within access to import this data back into access.
The problem is this: the edited data in the "original" fields updates OK, but the edited data from the "manually entered" fields do not update at all!
How can this be possible? Any help would be appreciated.
Alex~
