Import Text File Into Access

Discussion in 'Microsoft Access VBA Modules' started by mbc321, Apr 16, 2012.

  1. mbc321

    mbc321

    Joined:
    Mar 19, 2009
    Messages:
    1
    Likes Received:
    0
    Hello friends,

    I am having a lot of trouble to make a simple VB form to import a flat text file into Access. Following are a few lines of the text file:

    .S1 (ME,23,75,137;PE,41-42;S1E,63;S2E,57;S3E,54)
    Uses a variety of strategies in the problem-solving process
    .1.1.1.BP (ME,24;PE,22;S1E,63)
    Draws pictures to represent problems
    .......................................
    .......................................

    What I would like to have is import it into Field1,Field2 and Field3 as follows:

    Field1=.S1
    Field1=ME,23,75,137;PE,41-42;S1E,63;S2E,57;S3E,54
    Field3=Uses a variety of strategies in the problem-solving process
    Field1=.1.1.1.BP
    Field2=ME,24;PE,22;S1E,63
    Field3=Draws pictures to represent problems
    ........................

    Can someone please help me? Thanks,

    Farid.
     
    mbc321, Apr 16, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    import a tab delimited text file into access using ado

    Guest, Jul 14, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    419
    Guest
    Jul 14, 2005
  2. Guest
    Replies:
    1
    Views:
    590
    Allan Murphy
    Mar 2, 2006
  3. TerryM

    Parsing Text file and import into Access Table.

    TerryM, Sep 30, 2008, in forum: Microsoft Access VBA Modules
    Replies:
    13
    Views:
    6,391
    SwissGuy
    Oct 5, 2009
  4. Java

    Import Text File into Access Based on a Column Criteria

    Java, Jul 21, 2009, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    1,016
  5. info@trevorlarge.co.uk

    Import mutiple name text files into Access 2003

    info@trevorlarge.co.uk, Apr 27, 2012, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    770
    Douglas J Steele
    Apr 28, 2012
Loading...

Share This Page