Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: Can help with import text to Access?

    I must do import text (from files *.txt) to Access table fields.How I can do it?There are many text files.I must to do import to Access table.Who can help me?
    Last edited by jzas; 12-09-03 at 11:26.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb Re: Can help with import text to Access?

    Originally posted by jzas
    I must do import text (from files *.txt) to Access table fields.How I can do it?There are many text files.I must to do import to Access table.Who can help me?
    Use the DoCmd.TransferText as follow
    DoCmd.TransferText acImportDelim, , yourNewTableWhichWillContainTheDatat, PathAndFileNameWhereYourTextFileIsStored

Posting Permissions

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