Import Errors

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Johnb (anonymous_at_discussions.microsoft.com)
Date: 03/21/05 

Date: Mon, 21 Mar 2005 07:36:04 -0800

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. All cols are text data types.

Any suggestions ??

TIA johnb

Relevant Pages

  • Excel Data Importing
    ... might take a look at article: 129304 in the Micorsoft ... Knowledge Base. ... column 42 is where I am getting conversion errors all ... >Any ideas on how to proceed with the importing and avoid ...
    (microsoft.public.access.formscoding)
  • RE: Excel Data Importing
    ... Is there a function or method for checking the excel side of things to see what data type it is on the way in? ... column 42 is where I am getting conversion errors all ... >>Any ideas on how to proceed with the importing and avoid ...
    (microsoft.public.access.formscoding)
  • Import errors
    ... I am importing data from a SAP system into Excel XP and ... then altering a dog's dinner of a layout into 5 neat ... column/field which report 11 conversion errors in 850 ...
    (microsoft.public.access.externaldata)
  • Text File Import
    ... Access database. ... The layout of this text file contains a number and 5 ... dealing with this type of importing would be helpful. ...
    (microsoft.public.access.externaldata)
  • Re: Creating custom LayoutManager in NetBeans?
    ... LayoutManager class in order to have NetBeans accept it? ... and that the NB interface for importing custom layout ... managers does change from time to time... ...
    (comp.lang.java.gui)