Import From Excel

[Jmw]

I am trying to import an excel table to a table that already exists in the database, but i do not want to overwrite my data; i would like to keep existing data and be able to choose the columns that are imported to the database. So when i select: "Import the source data into a new table in the current database". I would like to import to an exsiting table, but this is the only option that lets me actually select the specific rows i want.


can you help please thank!!!

[JoeM]

In that scenario, I would probably import the data to a temporary table, and then use an Append Query to import just the records/fields you want into your existing production table.

[AnandKhinvasara]

It's really easy to achieve this.
When you go to External Data -> Excel (Under Import Section) - you would come across a screen which shows an option "Append a copy of the records to the table" . You can select the table you want it to be appended to, select the columns etc and have your data imported. Let me know if this helps.

[JoeM]

I was under the impression that the file that they are importing into Access has some of the records that already exist in the table, and then some new ones, and the only want the new ones added (which is why I answered the way I did). But in going back and reading it again, I see I may have misinterpretted that. If that is the case, and you want to import ALL the records in the file to an existing table, Anand's reply is the way to go. No need to complicate it.