M
mbparks
I am trying to import a table from Excel. I have tried setting up my table
in Access with the format for the columns pre-set and importing the data to
the pre-existing table.
I am getting an error "Unable to append all the data to the table. The
contents of 241609 records were deleted, 0 records were lost due to key
violations..."
The data deleted exists in 1 column. It is a mix of numbers (ex:
200000000123456) and text (ex: 0370015209458A or 0712390005-01).
I have also tried to change the format in Excel before importing but the
text format distorts the number data to look something like this: "2E+00". I
need to deep the information in it's original view.
Any suggestions would be greatly appreciated. Thank you.
in Access with the format for the columns pre-set and importing the data to
the pre-existing table.
I am getting an error "Unable to append all the data to the table. The
contents of 241609 records were deleted, 0 records were lost due to key
violations..."
The data deleted exists in 1 column. It is a mix of numbers (ex:
200000000123456) and text (ex: 0370015209458A or 0712390005-01).
I have also tried to change the format in Excel before importing but the
text format distorts the number data to look something like this: "2E+00". I
need to deep the information in it's original view.
Any suggestions would be greatly appreciated. Thank you.