Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    5

    Unanswered: Import text into table using macro

    How can I use a macro (or code) to import a text file into a table?

    I've tried using the following code:

    DoCmd.TransferText acImportDelim, , NewWork, "D:\Work.txt"

    but get an error message: Run-Time Error '2495' The action or method requires a table name argument.

  2. #2
    Join Date
    Aug 2002
    Location
    Québec, Canada
    Posts
    109
    You table name must be a string:

    Code:
    DoCmd.TransferText acImportDelim, , "NewWork", "D:\Work.txt"
    JefB

Posting Permissions

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