Results 1 to 4 of 4
  1. #1
    miziri is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    80

    copy data from text file into table in access

    Hi,
    I have text file contain data in line straight like this
    07504998547 01:10:05 01:10:45 AA
    1)I want this 07504998547 copy into filed in access table phone_no in access table


    2)I want 01:10:05 copy start_date in access table
    3)I want 01:10:45 copy end_date in access table
    4)copy AA into name in access table
    see attached two file access phone.mdb info.txt
    please make code in that file send me back
    thx

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The solution I posted in this thread should offer some ideas on how to solve your issue.

  3. #3
    miziri is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    80
    Hi RuralGuy
    I am look for solution

  4. #4
    miziri is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    80
    hi
    I saw that solution I will review it

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

Similar Threads

  1. Replies: 2
    Last Post: 04-29-2009, 11:50 AM
  2. Parse a File from a Directory and write data to table
    By galahad in forum Database Design
    Replies: 0
    Last Post: 04-23-2009, 08:38 AM
  3. COPY DATA and TRIM
    By Ed H in forum Access
    Replies: 1
    Last Post: 01-01-2009, 07:01 AM
  4. Exporting data to text file
    By NC_juggler in forum Import/Export Data
    Replies: 0
    Last Post: 11-21-2008, 10:51 AM
  5. Replies: 0
    Last Post: 09-21-2008, 11:28 AM

Posting Permissions

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