Import errors

  • Thread starter Thread starter johnb
  • Start date Start date
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
 
I suggest you tell us what data is being imported correctly and what
triggers a conversion error. Or would you rather we guessed?
 
Back
Top