Results 1 to 2 of 2

Importing .txt (tab delimited) file into Access 2007

  1. #1
    bcn1988 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2012
    Posts
    7

    Importing .txt (tab delimited) file into Access 2007

    I have a text file named "Listing_12032012" with the file path:

    C:\Documents and Settings\htq972\Desktop\Work Files\POR Reports\POR & PMOR Files\12-03-2012\

    So the full path to the file is:

    C:\Documents and Settings\htq972\Desktop\Work Files\POR Reports\POR & PMOR Files\12-03-2012\Listing_12032012

    I then have a table in Access 2007 named "ca-Project List"


    If I follow the import wizard, this is the following steps:

    1) External Data > Import Text File
    2) Browse > Select: C:\Documents and Settings\htq972\Desktop\Work Files\POR Reports\POR & PMOR Files\12-03-2012\Listing_12032012
    > Select Append a copy of the records to the table > Select: "ca-Project List"
    3) Select: "Delimited - Characters such as comma or tab separate each field" > Next
    4) Select: Tab > Select: First Row Contains Field Names > Select Text Qualifier: "
    5) Next > Finish

    I need the VBA code to automate this task! Can someone please help!

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Lake County, IL
    Posts
    1,982
    Here is a simplified tutorial on how to do it.

    http://www.datawright.com.au/access_...text_files.htm

    Post back if you have issues or get stuck.

    Alan
    If an answer has "resolved" your issue, then make sure to mark your thread as "solved." Did my answer help? Click on the '*' below.
    Relational Database Principles
    DataPig Access Tutorials
    Debug your Code​

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Importing from Excel 2007 into Access 2007
    By jk1809 in forum Import/Export Data
    Replies: 8
    Last Post: 09-06-2012, 08:46 AM
  2. Importing Text Delimited
    By BLD21 in forum Import/Export Data
    Replies: 2
    Last Post: 05-06-2011, 09:23 AM
  3. Replies: 5
    Last Post: 02-20-2011, 06:22 PM
  4. Replies: 1
    Last Post: 07-31-2010, 07:04 AM
  5. Importing a tab delimited file into access table - please he
    By championss in forum Import/Export Data
    Replies: 0
    Last Post: 10-29-2006, 01:33 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums