Upload Excel Data to Single Column in Access

[al8876]

Hi There,

I am very new to Microsoft Access so this probably a very easy question.

I cannot seem to find a way to upload several rows of data to one column in Access!

I have about 9 columns already in the table which have 900 rows each. These include names, numbers, address etc.

I was asked to add a column on next to the 9 columns with corresponding User ID such as 0093457FX (Which I really do not want to add manually).



Every time I try to upload an excel file the data either goes below the current data from the 9 columns on the new column and does not match the current data set, or it does not show up at all.

I am really hoping to be able to upload a single column onto Access.

Any help would be greatly appreciated!

Thanks!

[ranman256]

Adding a single column is easy, but are you wanting to MATCH the items coming in to those already there?
like row 1 coming in needs to go in row 23.

[al8876]

I have added the column in, but I need to upload data into it to match the corresponding data.

For example in Row 1 it will say:
ID: 1
First_Name: Joe
Last_Name: Smith
Phone:111-111-1111
email: email@test.com

for about 900 rows.

I have the corresponding data I would like to upload that matches it based on the Primary Key ID, but I cannot seem to upload that.

The corresponding data would be like:

Address: 1234 Parkview Rd.

For about 900 lines.

Thanks for the help!
Sorry if this is really bad question.

[ranman256]

then you need to do a join.
join the 2 tables on the matching field, then update the col.

[al8876]

then you need to do a join.
join the 2 tables on the matching field, then update the col.

Thanks for the help Ranman!

The tables are ODBC tables.

I was able to link the columns I wanted using a query.

How do I join the tables and then update the column?

Sorry for asking so much