Import Text File Into Access

Joined
Mar 19, 2009
Messages
1
Reaction score
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.
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Top