Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Connecticut
    Posts
    7

    Red face Unanswered: Import Data from Excel

    In an Access 2000 database (converted from Acc97), I am using this line to import data from an Excel file:

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, myTable, myFile, , "Detail!A6:AA1000"

    There are users who when they runs this code have records pull blanks for one of the fields . This field is set up as Text on the import table. The records in Excel contain data that are a mix of numbers and text (ex. DN, 1D, 23, etc.).

    On one user's PC, we changed acSpreadsheetTypeExcel97 to acSpreadsheetTypeExcel9 and it works fine. But, on another PC it makes no difference.

    Any thoughts.

  2. #2
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    Hi

    just to clarify - The data you are importing is from the SAME excel worksheet?


    You stated that the information coming over is a mix of text and number- how are the cells containing this information formatted?

    are they all text or a mixture of both so that they in fact have customised formatting ?

    regards

    gareth

Posting Permissions

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