Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data Converstion errors - Excel to Access (Both Office 97)

    I am merging three Excel files (from differenct sources) into one Access database. I merged them all in Excel first to
    get the data organized in common columns. I then selected whole columns in Excel to apply consistent formatting.
    When I import it I get a lot of Conversion Errors (mostly dates but some numbers, too). Whole columns do not get
    kicked out - only large chunks of data from certain columns. So I went back to the Excel spreadsheet and picked one
    record that worked and pasted that record's formatting over the ones that didn't. Still no luck. Finally worked around
    temporarily by making all fields text. Not much use for the long run though. Thank you for any suggestions you can offer.

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Converstion errors - Excel to Access (Both Office 97)

    Now you have the data in Access have you tried using Access to convert it back to numbers, dates etc.??

    Peter

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Converstion errors - Excel to Access (Both Office 97)

    Beware of empty cells at the top of your columns. <img src=/S/cauldron.gif border=0 alt=cauldron width=20 height=20>
    You may want to fill in some 'filler' data in the top record of the final merged sheet
    which insures there is data in the first cells when it imports.

    For instance if you have a column of numbers and you just want them as text , then drop in a few capital AAAs.
    Obviously for numeric, you want a different approach. You can always filter them out later, cuz it's at the top of the stack.

  4. #4
    New Lounger
    Join Date
    Jan 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Converstion errors - Excel to Access (Both Office 97)

    Thank you for your reply to my post last month. I did try this and it worked for most of the columns I was having problems with. I finally took the 4 or 5 remaining columns and moved them back into Excel individually and just kept beating them up until they behaved the way I wanted them to and then copied them back into the Access database.

    Thanks again for your help and sorry for the belated response.

Posting Permissions

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