Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    May 2002
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import problems (97)

    When I try to import a very large Excel file into Access i am having troubles. The import works, but when I go look at the data some of the data is in the wrong field. For example one record might have a name in the SSN field. Another might have SSN in the Zip field. I looked at the Excel file and everything is in the right spot there. What is going on?
    Thanks
    Dgw

  2. #2
    New Lounger
    Join Date
    Nov 2002
    Location
    Miami, Florida, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import problems (97)

    This is not really related but it might be something to look at...

    Does the Excel file have null fields?

    When I import sequel queries from a Cobol database into Excel (using Client Access), if there are any null fields, they get populated with whatever value the importing program last saw.
    (Ex: the cell in column F = 8, the cells in columns G and H were null - all 3 columns would be 8)
    Now, I use 0s instead of leaving cells blank.

    Chris

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Import problems (97)

    One thing to check for is commas within fields in Excel. If the data wasn't originally created in Excel, commas may cause imported data to split into several columns unexpectedly. The easiest way to get around the problem is to link to the Excel sheet instead of importing, and then do an append query from the linked sheet to whichever table you want.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •