Issues appending Excel data to Access Table
I can import excel data to a new table with no issues.
I cant however import the same data to an existing table.
I exported the original table to excel as a template so I know my column headings are correct and I formatted the excel columns to the same data type as the table.
I have no primary key in the excel spreadsheet
When I import and append I get the following error -
There are no further errors but no data what so ever is imported to the table. If I trim my import file to anything, 1 record, 1 record with 1 column tc etc I still get no import.
Microsoft Office Access was unable to append all of the data to the table.
The contents of fields in 0 records(s) were deleted, and 0 record(s) were lost due to key
Am I missing something?