how to update database from excel file, use copy/paste?

[Niven]

Hello,

I have an excel file with 4 coloumns, and the database (access 2003) has more than 4 coloumns, is there a way for me to use the data import wizard to update the database. there are entries in the database that also correspond to the excel doc, but the excel doc has data that is more uptodate.

is there a way for me to just copy and past the excel data into the 4 coloumns that correspond? I keep getting an error when i do that.

your reply is appreciated.

thank you

[alansidman]

you should import your excel spreadsheet into a temporary table in Access. You should then run an update query on the temp table to update the main table.

Look here for how to do an update query.

http://www.databasedev.co.uk/update_query.html

[Niven]

you should import your excel spreadsheet into a temporary table in Access. You should then run an update query on the temp table to update the main table.

Look here for how to do an update query.

http://www.databasedev.co.uk/update_query.html

Im really having difficulty doing an update query, i tried reading that but it seems complex. The actual databse has 12 coloumns with about 4000 entries. I have a excel spreadsheet with only 4 columns correspond to the original database. Data in the 4 coloumns are also repeated in the actual database, but with some updates. WHats the easiest way of doing this, cant I just copy and paste/replace?

please help

[alansidman]

What issues are you having doing an update query? Your latest thread is a repeat of what you stated in the original. Help us to help you. More information. The easiest way is an update query. What steps did you attempt and what results did you obtain. Would you like to upload some sample data of your current db and some sample data of your excel spreadsheet. If you do this, tell us what your expected results should look like. Without more information, it will be difficult to give you any better response. At this point we would be just guessing as to what the issues are.