By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,247 Members | 1,287 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,247 IT Pros & Developers. It's quick & easy.

how to update a normal table from an excel linked table

P: 76
Hello Guys
I have a linked excel sheet to MsAccess 2007.* In order to make extra changes to the information, I have to make a normal table in access.* Then add fields so it can be modified, as I cant modify or change anything in the linked sheet.
Is there a way to update WipMasterTbl from the linked excel table "WipMaster" and only add new records that are not in the table "WipMasterTbl " and also change the values if the excel sheet has changed.
I've tried the update query but I dont get it to work.* If I append then it adds all the records again!
Please Help
Feb 17 '11 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
It's not clear if this question is about using data from an Excel Linked table or how to manipulate data in a database.

I suggest the first thing you should do is to append the data from Excel into a local Access table if you're unsure about the limitations of a linked table.

As far as data manipulation is concerned, it is the same as you would expect to do in a database. Appending data is done using an APPEND query, and updating is done in an UPDATE query. Your WHERE clause can be used to ensure that the append data only is applied in the APPEND query and the same is true for the data required in the UPDATE query. There is no facility to do both steps within the same query.
Feb 17 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.