Re: Using Excel data in a VB6 database
- From: Duane Arnold <"Do forget about it"@PleaeDo.BET>
- Date: Sun, 03 Sep 2006 13:12:35 GMT
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 :)
.
- References:
- Using Excel data in a VB6 database
- From: Henk van Winkoop
- Re: Using Excel data in a VB6 database
- From: Duane Arnold
- Re: Using Excel data in a VB6 database
- From: Henk van Winkoop
- Using Excel data in a VB6 database
- Prev by Date: Re: Using Excel data in a VB6 database
- Next by Date: Re: Dijkstra's algorithm for shortest paths
- Previous by thread: Re: Using Excel data in a VB6 database
- Next by thread: Dijkstra's algorithm for shortest paths
- Index(es):