On Wed, 28 Jul 2010 08:04 +1200, "Sytze de Boer" <[email protected]>
wrote:
> However, in this instance, I've ended up with a 'cursor' which is full
> of .NULL's, heaps of memo fields and just a few fields with numeric
> data.
> I guess I could try and make it work but a huge amount of work.
>
Yes, you'd have to do a bit of post-processing but in my own case the
advantages of not having to worry about the version of Excel make it
very worthwhile. I just get it into a preliminary cursor with the ODBC
calland then parse it into my real cursor which I've created manually,
e.g.
Select ExcelCursor
Scan
Scatter Name loRaw
Select MyRealCursor
Scatter Name loParsed
loParsed.num1 = val(loRaw.field1)
loParsed.date1 = ctod(alltrim(loRaw.field2))
Append Blank
Gather Name loParsed
Endscan
use in select("ExcelCursor")
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
