Import Text File Into Access

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

  1. mbc321

    mbc321

    Joined:
    Mar 19, 2009
    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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    Import .jpg file names into Access

    Guest, Feb 21, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    312
    Guest
    Feb 21, 2005
  2. Guest

    Import .jpg file names into Access

    Guest, Feb 21, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    357
    Guest
    Feb 21, 2005
  3. Guest

    Using ADO to import a text file into an existing table structure

    Guest, May 3, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    3
    Views:
    1,938
    Alex Dybenko
    May 3, 2005
  4. Guest

    import a tab delimited text file into access using ado

    Guest, Jul 14, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    649
    Guest
    Jul 14, 2005
  5. Guest
    Replies:
    1
    Views:
    753
    Allan Murphy
    Mar 2, 2006
  6. TerryM

    Parsing Text file and import into Access Table.

    TerryM, Sep 30, 2008, in forum: Microsoft Access VBA Modules
    Replies:
    13
    Views:
    7,625
    SwissGuy
    Oct 5, 2009
  7. 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,222
  8. 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:
    862
    Douglas J Steele
    Apr 28, 2012
Loading...