New Column to Existing Table

R

Richard

I need help adding a column to an existing table. The data I would like to
add is located in an Excel spreadsheet. I do have a primary key that I can
use for indexing the correct values into the correct rows. How can I easily
import my new data into my current table? Please note I am a novice and don't
have programming experience. Is this possible without placing this data in a
seperate table?
 
A

Arvin Meyer [MVP]

Add the column to the Access table

Link the Excel spreadsheet to Access:

File >>> Get External Data >>> Link Tables

Change the file type to Excel and connect the Excel sheet. Then create a
query. that links the Excel "table" to the Access table and run an Update
query. Something like:

UPDATE tblAccessData INNER JOIN Sheet1 ON tblAccessData ID= Sheet1.ID SET
tblAccessData.NewAccessColumn= [Sheet1].[ExcelColumn];
 
Top