Upload data from Excel to Access

[wingale]

Hi all,

I have an access mdb file and just added a new field to one of the tables.

I also have several spreadsheets with bits of information that I would like to use to update the newly created field for each record.

Not sure what is the best way to approach this. Can I use a query that will look into the spreadsheet and copy the specified cell to the newly created field using an if statement? or

Do I need to get all data into a table and upload as a new table in Access then use query to update the records?

Please keep in mind that I do not wish to append new records, I need to update existing ones.

The above represents my thoughts on how to approach this task, I would appreciate any help.

I must also state that I am totally new to access and would appreciate as much detail as is possible in the response(s).

Thanks,
Wingale

 

[Penmore]

If the data records you have in the Excel sheet match the data in your Access table can you not just copy and paste the column from your Excel sheet to the column in your Access table?

I've copied an entire table from Excel to a new table Access but I had to have the records in place in the Access table before I could do the copy'n'paste as it would not insert new records.

Make a copy of you existing table and try it