Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Thanked 0 Times in 0 Posts

    Auto import from text file (2003)

    There are one text file that need to be imported daily with import specs already in the database. Here is what I am doing now:

    I need to Import text file - Import - Advanced - Specs (choose Test structure) - Next - Next - Next - No Primary Key - create tbl_test table.

    I have tried the following codes, but I got import error table with "Conversation error" and all blank valume in tbl_test table.

    DoCmd.TransferText acImportDelim, "Test", "tbl_test", "c:test.txt"

    So why the codes were not working?

    Thanks in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Auto import from text file (2003)

    Without seeing a representative sample of the text file it's impossible to say (assuming that your import specification is really named "Test" and not "Test structure").

    Does Access create an Import Errors table when the import fails? If so, do the records in this table give a clue?

Posting Permissions

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