Add new columns and corresponding data to a table.

[danaspps]

Total newbie here. I have a table with 1137 records in it. I want to add several additional columns to the table. I have the data for those columns in an Excel spreadsheet. I need to know how to import that data into the existing table. I have a column in the Excel sheet that is the same as the primary key in the Access table.



I greatly appreciate any help, but please dumb it down for the newbie.

[pbaldy]

For starters, I'd want to be sure that adding columns was the correct solution. If you have product1, product2, etc, it's probably not. That said, you can link to the Excel file (External data tab) and then create a query that joins the 2 tables together on the key field. Then change that query to an update query, and update each Access field to the corresponding Excel field.

[CarlettoFed]

Perhaps by attaching the excel file, with a minimum of data and replacing the sensitive ones, you would make it easier to understand the problem directly and therefore advise you on how to act.

[danaspps]

I have attached the Excel file as requested. The table in the database has SKU as the primary key, so this would be adding information to existing records. The database is to large to attach.

[CarlettoFed]

What is the action you should do just to add new SKUs or also update existing SKUs?

[June7]

Review https://stackoverflow.com/questions/...g-in-ms-access

[danaspps]

I decided to go a different way and just created a separate table and form for this information. At least this way I know what I am doing. I appreciate those of you who read my post and tried to help. I assume I should close out this thread somehow but not sure that marking it as solved is appropriate.

[Welshgasman]

At least this way I know what I am doing

Always the best path to take