Re: Using Excel data in a VB6 database

Richard Heathfield wrote:

Why not just dump the data from Excel into a CSV file? That's easy enough
to
read into VB.

Ah, yes. VB Classic. As I recall, it has the power and subtlety to make
simple text parsing as clean and elegant as an airport security queue on a
Red day.

To the OP: Use the ADO database library, with an Excel OLEDB driver, to open
the spread*** as a database.

--
Phlip
http://c2.com/cgi/wiki?ZeekLand <-- NOT a blog!!!


.