Re: Using Excel data in a VB6 database

....ongoing report...;-)

Also using komma-delimited files when NOT using DEV results in errors when
updating records.
Microsoft support says:
"The ODBC textfile driver does not support DELETE and UPDATE statements."
and advices to use Access .mdb files.

So I think I will resign from using comma-delimited files itself as a
database for my VB6 application.

Logan wrote
I recall hearing somewhere that you can actually use an
ODBC driver to access an Excel document. Of course, that's
a gross hack, but it is Microsoft software, so...

I will try to establish importing an Excel file directly into an .mdb
database by my VB6 application.

Still some questions remain:
- can a VB6 application CREATE an .mdb database at runtime? or...
- can a VB6 application convert/import an Excel *** directly INTO a NEW
..mdb database at runtime?

Hints are very welcome,
in the mean time I will study this material and find out

Regards,

Henk

"Henk van Winkoop" <h.van.winkoop@xxxxxx> schreef in bericht
news:44fab828$0$2027$ba620dc5@xxxxxxxxxxxxxxxxxxxxxx

"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





.