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:37:55 -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.

Any suggestions ??

TIA johnb

Relevant Pages

  • Re: Multiple spreadsheet import
    ... importing data from all files in a folder. ... If those conditions don't hold (e.g. importing multiple sheets from one ... Dim strfile As String ...
    (microsoft.public.access.externaldata)
  • 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.gettingstarted)
  • Re: Primary Key help
    ... >consistent structure for importing data from text files. ... >Since I've switched to SQL to handle my databases I must ... >use a primary key so the data can be modified. ...
    (microsoft.public.access.tablesdbdesign)
  • How to move data on worksheet
    ... What i would do is make it all one tier, ... name then link to it instead of importing. ... >importing data from Excel and I want to be sure I start ... Can the repositioning be done by command ...
    (microsoft.public.excel.misc)
  • Re: #NUM! error
    ... Not sure what you mean when you say "the unary returns a zero". ... First, if you're importing data, it's unlikely that you'll have a ... ensure that inputs are of the proper form. ...
    (microsoft.public.excel.misc)