Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing Excel data (2003)

    I have run the hotfix from MS to allow me to import Excel data into Access. It now allows me to do most things but not format the columns coming in. This leads to problems on staff number columns that have leading zeros - used to be able to import them as text - now they come in as numbers. Does anyone know if a further update from MS is likely on this? I can get around the problem but wondered if anyone knew if this was going to be fixed soon. I cannot find it on the MS website.
    Neil Eustice
    Woody Worshipper

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Importing Excel data (2003)

    I don't think anyone of us has an inside connection with Microsoft, so your guess is as good as anyone else's.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Excel data (2003)

    No worries - you never know - sometimes one person sees something another doesn't, hears something another doesn't. I will post the problem with Microsoft.

    Thanks
    Neil Eustice
    Woody Worshipper

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Importing Excel data (2003)

    The strategy we typically use in this case is to define a table in advance that specifies the field is text, and then import into an existing table. We usually either delete the table once we've finished, and then create a new tabledef either in code, or by copying an existing table. That approach assumes of course that the user creating the Excel workbook has a fixed format and hasn't inserted or deleted columns in it. Hope this helps.
    Wendell

  5. #5
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Excel data (2003)

    Good tip - thanks.
    Neil Eustice
    Woody Worshipper

Posting Permissions

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