Results 1 to 3 of 3

Thread: Import Problem

  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Import Problem

    Hi

    I have a problem for import the Excel file into Access.

    It cannot be import all data. Could you help me to check it?

    File Num has 2 datatypes: Number and Text. I already set the column to be Text datatype in the Excel. But, when I import the excel file into Access.

    It cannot import all data.

    Please let me know, thanks.

    Thanks.
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2004
    Posts
    27

    Thumbs up

    Check It Out
    Attached Files Attached Files

  3. #3
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    I suspect that you get records with either #NUM# or #NAME# showing up in access

    if this the case you need a small macro in the excel file that is used to force the data to TEXT - this issue is known in the access/excel domain (many of us have been here)

    If this is the case let me know ASAp and Ill post the macro for you

    gareth
    Last edited by garethfx; 10-14-05 at 17:40.

Posting Permissions

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