New Column to Existing Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 18 Jan 2008 17:31 GMT

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?

Reply to this Message

Arvin Meyer [MVP] - 18 Jan 2008 17:45 GMT

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];

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>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
[quoted text clipped - 6 lines]
> in a
> seperate table?

Reply to this Message