Text Import

A

AccessHelp

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.
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import errors importing Text into existing table, header vs no hea 3
some records will be imported from excel 0
Adding a big matrix in Word 2013 5
Excel does not accept text format! 0
Import from Excel with some bad dates causes no records to import 1
VBA - (re-) Set a Table Style 2
Access 2007--where is the "Paste Error Table" 0
Importing records in tables 1

Top