Converting .txt (ordered by rows) to an Access .mdb

[signature]

Our company uses Fedex online. Fedex online offers a download of your shipping history to be saved. The format is txt. The data comes in such as this:

Tracking Number: 999999999999 Date May 1 2002 12:00
John Doe
Company Name
Department
100 Main Street
Anytown
99999
US
9999999999

I have been unable to convert this data to a table or add to a table. I'd at least like to have the date and the Company name to run query's along with other databases related to the Fedex shipped data.

I know there must be a way..I have been having problems because the data is in rows and not typical columns..

Thank You

 

[THoey]

Two thoughts...

1. Write a bunch of code to go through read a line, fill a couple variables, read another line, fill a couple more variables, etc until you have the complete record and then write the record to a table.

2. Buy an application called Monarch at this site:

http://www.datawatch.com/products/monarch.htm

Hope that helps... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...