Ok, i'm so use to doing conn.execute that I often forget about adding records that way. I need to mod it alil then I'll get back to you on how it works... you are a big help. Thnx

I am still not clear on the structure of the data, though. If each #-@ is a seperate reading from the wrench, then each line would have multiple records, instead of each line having one record. So that makes a difference in how you shove the data into the table. Please clarify.

mmcdonal

Cna I count the amount of arrarys there are that have values?

intx = arrary(x).count or something like that?

I wish I can contructed the data file myself but the engineers here are using a generic hyperterminal app called Tera Term Pro. It logs data in one long line. Then they call me and tell me to make heads or tails of it. Max measurements should be 20 hopefully. If I could attach the file so you could see it I would.

You use UBound(MyArray) which returns a numeric value of the number of elements. Remember to add 1 since it starts at 0.

So if UBound(MyArray) = 2, there are 3 elements: 0, 1, 2.



mmcdonal

What I need to know is, in the first line that you showed me, what will you be storing and where?

mmcdonal

I'll be storing Torque values and in an access database for weekly reports on value that where torqued High/Low.

I get it. You will then need to store the date and time the data was retrieved. Are any of the values in the data date and time stamp data? Which part of the data is torque spec, wrench id, date and time, if any? That would be ideal. Otherwise you will just stamp the time the process was run.



mmcdonal

The app called Tera Term that actually gets the data from the wrench stores the data for each wrench in a diff file. IE: Toola, Toolb, Toolc. The form I'm creating will add generate a random record ID and store the record for each transmission in Table Toola, Toolb, and Toolc all with same record ID and date/time stamp.

So what you will need to do is to create a table with an autonumber field, the data field from the file, and the date/time. So Toola table should look like this:

tblToolA
ToolaID - auto: PK
Data - text: 12005055.00000000441526
DateTime - date: Now()

Also, it sounds like each line has, in this case, 12 records. So the line you posted needs to be split into 12 parts, then each of those 12 parts has to have its own record, with PK, data, and datetime. If that is the case, then the code I posted needs another nested loop.

Are we getting closer? It is all very easy if we have the requirements right.



mmcdonal