Using Datalog files in Access

[cfordyce]

I have a OPC Server application logging data from a PLC on the Plant Floor. The application is called INFILINK and it creates the log files in many different formats. e.g. DBF, DLF, IDX, MDB.
I log 5 pieces of info every time a production machine stops. When I open the log file in Access, each individual piece of info is in it's own record. So for each machine stoppage, I get 5 records.
I would like a single record consisting of all five pieces of info to be created for each stoppage, instead of 5 individual records.
Can I convert this info into the new format using Access? How?

old format:
Name Value Date Time
Rec1: infoA 10.3 04/04/04 10:20
Rec2: infoB 1234 04/04/04 10:20
Rec3: infoC 13.3 04/04/04 10:20
Rec4: infoD 6789 04/04/04 10:20
Rec5: infoE 111.1 04/04/04 10:20
Rec6: infoA 11.4 o4/04/04 10:26
.....etc.

new format:
infoA infoB infoC infoD infoE
Rec1: 10.3 1234 13.3 6789 111.1
Rec2: 11.4
....etc.

 

[randysmid]

Hi,
You should be able to do this quite easily with a Make-Table query. The default query type in the Query object is "Select Query", but you can change this to one of the 5 other types: Crosstab, Make-Table, Update, Append, Delete. Simply click on the Query menu item, and select the appropriate option.

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association