Can I import un-organized text information into a table

D

Dave

I have text information being supplied to me that I want to import into
Access.

The information looks like this:

Passenger: SMITH JOHN Ticketed: 01/10/2005

Locator: BAORZC Agent: K4 Fare Cost: $364.90
01/30/2005 AA692 S Depart SEA 1:24 PM Arrives DFW 7:11 PM
02/04/2005 AA2203 N Depart DFW 4:18 PM Arrives SEA 6:34 PM
Passenger: JONES MICHAEL Ticketed: 12/20/2004

Locator: BZQOBX Agent: K4 Fare Cost: $238.20
01/05/2005 DL5076 U Depart PIT 5:45 PM Arrives CVG 7:08 PM
01/07/2005 DL4099 U Depart CVG 7:15 PM Arrives PIT 8:31 PM

I could separate a record by the key word passenger and columns by
passenger, fare cost, depart arrives.

Is it possible in Access to pull data into a table based on key words or is
there a tool that could pull this information into usable data?

Thanks!
 
J

John Ortt

I think you would have to write code to put it into the table...
I would try myself but I'm not really good enough :(
 
J

John Vinson

I have text information being supplied to me that I want to import into
Access.

The information looks like this:

Passenger: SMITH JOHN Ticketed: 01/10/2005

Locator: BAORZC Agent: K4 Fare Cost: $364.90
01/30/2005 AA692 S Depart SEA 1:24 PM Arrives DFW 7:11 PM
02/04/2005 AA2203 N Depart DFW 4:18 PM Arrives SEA 6:34 PM
Passenger: JONES MICHAEL Ticketed: 12/20/2004

Locator: BZQOBX Agent: K4 Fare Cost: $238.20
01/05/2005 DL5076 U Depart PIT 5:45 PM Arrives CVG 7:08 PM
01/07/2005 DL4099 U Depart CVG 7:15 PM Arrives PIT 8:31 PM

I could separate a record by the key word passenger and columns by
passenger, fare cost, depart arrives.

Is it possible in Access to pull data into a table based on key words or is
there a tool that could pull this information into usable data?
Click to expand...

Not directly. You would need to write VBA code to parse it out, and it
looks like it would be pretty difficult. I can see all sorts of issues
- the passenger name might have two, or three, or four words; there
would be an arbitrary number of itinerary lines. The code will really
need some intelligence to determine what should go where.


John W. Vinson[MVP]
 
Top