Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2008
    Location
    Wheaton, Illinois, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing from Excel (2002 SP3)

    I have data in Excel 2003 SP3. I saved a worksheet as a 4.0 document. From an Access table, I try to use "Get Data from External Source/Import" and there's an unspecified error, and there is no data brought over.

    My fields in Excel are mostly simple numbers or text. They are the same as my Access table structure. What I'm unclear about is the cell format compatibility. In Access I have a date field. In Excel I formatted the field to the same type of date. In Access I have an input mask (ZIP Code). I unhid all the columns (fields) in Access and have the same column headings in Excel. I named them what the Table View calls them and specify that the top row of my Excel worksheet is column headings.

    Any help?

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

    Re: Importing from Excel (2002 SP3)

    Have you tried saving the workbook as a standard Excel 97-2003 workbook? Does that make a difference?

  3. #3
    2 Star Lounger
    Join Date
    Jan 2008
    Location
    Wheaton, Illinois, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing from Excel (2002 SP3)

    Yes, same error:

    An error occurred trying to import your file [path]. The file was not imported.

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

    Re: Importing from Excel (2002 SP3)

    Could you attach a copy of the workbook (stripped down if necessary)?

  5. #5
    2 Star Lounger
    Join Date
    Jan 2008
    Location
    Wheaton, Illinois, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing from Excel (2002 SP3)

    Here's the workbook.
    Attached Files Attached Files

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

    Re: Importing from Excel (2002 SP3)

    I could import the the worksheet without problems in Access 2002 SP3 into a new table, but the first field came in as text because there is a text value in cell A20, and this also caused Access to import too many rows.

    I then deleted all records from the imported table and changed the first field to Date/Time.
    I opened the Excel workbook and deleted the extraneous rows and saved it.
    The workbook then imported correctly into the existing table.

Posting Permissions

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