Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    2

    Unanswered: Importing multiple text files in to Access (Module)

    Hi,

    I wanted to use the "module/ macro" feature for importing multiple files into MS Access. I have several text files all in the same format (and same delimiters) without header rows. I could save all these files in to their own Folder.

    Could someone guide me here? Please let me know if you need more details.

    Thanks!

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266

  3. #3
    Join Date
    Nov 2006
    Posts
    2
    Thanks! This works well. Just a small question - I get a number of Import errors (all the same for "Type Conversion Failure").

    Essentially, I get one large table with the same import errors and all the files appended to the large table. I've figured out a way to have individual txt files as different tables in Access, since each txt file has multiple records and multiple fields.

    Should I be concerned with these errors? I do not want to miss out on any of the records within each txt file.

    Thanks!

Posting Permissions

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