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!