PC Review


Reply
Thread Tools Rate Thread

Import Text File Into Access

 
 
New Member
Join Date: Mar 2009
Posts: 1
 
      16th Apr 2012
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Excel File into Access DB where user can specify file name andcell range to import ssa Microsoft Access External Data 1 18th May 2011 01:18 AM
Text import wizard does import properly beyond text file line 1048 Bas V Microsoft Excel Discussion 5 22nd May 2008 12:19 AM
Import an Excel File into Existing Table not using the Import Wiza =?Utf-8?B?TG91aXNl?= Microsoft Access VBA Modules 1 2nd Mar 2006 11:01 PM
How to automate import from a text file into access table - URGENT ljubo lecic via AccessMonster.com Microsoft Access Forms 1 23rd Feb 2005 05:58 PM
Import text file into access little_rascals Microsoft Access 1 12th Jan 2004 07:10 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:19 AM.