Re: Using Excel data in a VB6 database


"Duane Arnold" <"Do forget about it"@PleaeDo.BET> schreef in bericht
news:dujKg.5259$bM.4364@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
You should be able to dump the Excel data out to a comma delimited text
file. Just about all database solutions have a comma delimited text data
means to import the data into a table. You can use ADO to access the
database and the table using VB 6.

Duane :)

I experimented with ADO and using DataEnvironment (DEV, my abreviation) with
VB6.

As documentation says that interfacing is easier to develop with DEV than
without, I experimented
with it.
But it seems that (using Microsoft JET 3.51) DEV does not accept using plain
textfiles
with comma-delimited content.

Or is there some trick to it?

Henk



.