Text Import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 25 records that I copy from Excel to Access table. When I do that, 21
records got pasted in the table, and 4 records go into the Paste Error table.


I know the error of this problem. The error is "Type Mismatch". So what I
did was I tried two things. The first thing is I did the Paste Paint on the
4 bad records using the 4 good records in Excel. The second thing is I
reformat all 25 records in Excel based on the types in Access.

I am still getting kicked out on that 4 records. Please help!

Thanks.
 
Two things to try --
If you know the error change the datatype of the Paste Error table. Then
copy the Paste error records to your table - Paste Append

Other method --
In the Excel file click in the cell and then press enter. Do this for each
cell that was not formated correctly before.
 
Back
Top