Forum Thread

Auto transcribe data from MDB to XLS

Dr. J 25,043 3,353 November 23, 2015 at 05:53 AM
For work I have to deal with software that dumps data out to an MDB. That isn't so much the problem as the manner in which the data is stored.

Ideally I'd like it columnular:
Time - Data 1 - Data 2 - Data 3 ------
Time1 - Value1 - Value2 - Value3 ------

But it appears the MDB is stored as blocks of data in rows ROUGHLY by time (see attached).

"ItemID" is a value that corresponds with a certain type of data I am logging - 38 may be one temperature zone and 37 another. "NumValue" is the numeric value of that data - for example From 8:18:05 to 18:18:35, data 38 (a temperature) had an actual value of 20.

If I could condense this to the tabular type of data above for each ItemID (I have probably 15) with values and corresponding times, that is the goal.

Note that not all ItemID's have the same time spacing. This isn't really important to me - each data set could have its own associated time, that's fine.


Start the Conversation
Add a Comment
Copyright 1999 - 2016. Slickdeals, LLC. All Rights Reserved. Copyright / Infringement Policy  •  Privacy Policy  •  Terms of Service  •  Acceptable Use Policy (Rules)  •  Interest-Based Ads
Link Copied to Clipboard