how to merge

B

bagnallc

Example

If i have an access database with columns ID, Dog Name, Dog Type with
say 500 records, how do i now add another 500 records stored in an
excel spreadsheet with exact same format and headings.

I am trying to use get external data and then "add to existing table"
but it is not allowing this.

Any ideas why?
 
N

nanne

it works fine, if the fieldnames in the first row of the spreadsheet are
exactly the same as the fieldnames in the table
 
T

Tom Lake

If i have an access database with columns ID, Dog Name, Dog Type with
say 500 records, how do i now add another 500 records stored in an
excel spreadsheet with exact same format and headings.

I am trying to use get external data and then "add to existing table"
but it is not allowing this.
Click to expand...

Why not link to the Excel then use an Append Query to add that data to the
Access table?

Tom Lake
 
Top