Text Import

[JB_96RS]

Is there any noob tutorials out there to help with text importing/specifications? I have text files I want to import to a table. There will be new records for each file that is brought in. I've tried to use the wizard but I can never get the data to go where I want it. The files contain many data points, but I need little info from them: "Lot Id" number, "Date", and "AVG"

The file looks like:

Run id test 8, 81 pt l/s ID test 8, 81 pt l/s
Operator OLTproc Description
Date 2004/01/21 10:36:20
Cassette Front
Size 300

*******100 ROWS OF JUNK HERE*******

Thickness average: 4.3214 deviation: 0.0879

So what I would need is: the data to go into a table with 3 fields: Lot, Date, and AVG. Is this possible?


Thanks,
JB

 

[Pat Hartman]

You can't use any of the import methods to import files structure in this way. The TransferText method works on files with IDENTICALLY formatted rows. Each of your rows seem to have a different format. You will need to write custom VBA code to read each row, decide what it contains, and create a table with the desired columns. There have been postings here that include code for importing and exporting data via VBA. You can search for them.

 

[WayneRyan]

JB,

If you can post your table structure and a copy of the file, with
explanations, I'll give it a shot.

Wayne