If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update Link Tables from Excel
I recently got an update from Office 97 to Office 2003. We're just slightly
behind the times. Anyway, I had an access database in 97 that would link to an Excel file that I would use to add data to the Excel file based upon information in a master table in Access. Now when I try to run the query in Access 2003, it gives me an error that it is not an updateable query. I suppose I could export the master data to an Excel spreadsheet and use a VLookup function, copy and paste to all the records that need to be updated and the copy and paste values, but I originally did this in Access to make it simpler. Any ideas why it no longer works? Thanks! |
#2
|
|||
|
|||
Update Link Tables from Excel
Nevermind - foundthis statement on article 904953:
Because of legal issues, Microsoft has disabled the functionality in Access 2003 and in Access 2002 that let users change the data in linked tables that point to a range in an Excel workbook. However, when you make changes directly in the Excel workbook, the changes appear in the linked table in Access. Probably should have stayed with 97. "BlairH" wrote: I recently got an update from Office 97 to Office 2003. We're just slightly behind the times. Anyway, I had an access database in 97 that would link to an Excel file that I would use to add data to the Excel file based upon information in a master table in Access. Now when I try to run the query in Access 2003, it gives me an error that it is not an updateable query. I suppose I could export the master data to an Excel spreadsheet and use a VLookup function, copy and paste to all the records that need to be updated and the copy and paste values, but I originally did this in Access to make it simpler. Any ideas why it no longer works? Thanks! |
Thread Tools | |
Display Modes | |
|
|