Import errors

J

johnb

I am importing data from a SAP system into Excel XP and
then altering a dog's dinner of a layout into 5 neat
columns. I then import the columns into Access XP table.
I've automated it and it works fine apart the middle
column/field which report 11 conversion errors in 850
records when it arrives in Access. The data is correct
when it is imported to a table in Access. If I append
say "#" to the first character position to this middle
field it imports without any errors at all. I've tried
using Trim and Copy-Paste Special and values but no
success.

Any suggestions ??

TIA johnb
 
J

John Nurick

I suggest you tell us what data is being imported correctly and what
triggers a conversion error. Or would you rather we guessed?
 

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 1
Import errors importing Text into existing table, header vs no hea 3
Importing excel into access 2
Access crashes when I try to import an excel file 7
import csv conversion & import spec error 1
Import Spec-Germany 0
Access 2003 -- Importing Text File -- Nulls 1
Losing long numbers regardless of format 2

Top