Re: Using Excel data in a VB6 database



Henk van Winkoop wrote:
"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?


See my other post.

Duane :)
.