sparks wrote on 10/20/2011 :
I was sent an excel sheet that came from one of those $200K machines
and they expect it to be imported into an access database.

the data looks like this

10/17/2011 4:24:20 4:24:35 4:24:50 4:25:05 4:25:20
BOB1 125 122 120 123 111
BOB2 0 0 0 0 0
BOB3 0 0 0 0 -0.1I

just a small part this is 40 variables over many hours.


but what I need is name date time value

varname=bob1
date=10/17/2011
time=4:24
value=125

varname2=BOB2
date2=10/17/2011
time2=4:24
value=0



how the heck can I get the data from this?
I told them this looks like a report not data.
Can you get it out as a csv.

I got the typical glassy stare.

If the file IS a CSV and not XLS[?] then you have 2 options; import as
CSV into Access (probably the easiest), -OR- read the file into an
array and write it to the access database using ADO.

If it is XLS[?] then you can do the latter of the above as I'm not sure
if Access can import from an Excel file directly, but you could do it
in Access via VBA using ADO.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc