Re: Using Excel data in a VB6 database

Henk van Winkoop wrote:
Hello,

My VB6 application needs customer data like
name/address/place_of_birth etc.

This customer data is available in Excel sheets.

I think the easiest way is to use some database which is
controlled by VB6. But thats all I know. I am familiar
with .mdb databases. But I do want to use my VB6
application without any MSAccess application.

My question is:
- what kind of database do I need?
- how do import the excel-data into this VB6-controlled database?

Thanks in advance,

Henk


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 :)
.