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.

Applications can use .mdb files without the MS-Access
application.


My question is:
- what kind of database do I need?

MS-Access. Look in your VB6 documentation. There's surely
information there on how VB6 can use all MS-Office document
types.

- how do import the excel-data into this VB6-controlled database?

That will depend on how the spreadsheets are organized. If you're
lucky, the work*** rows are directly compatible with database
records making the task one of simply reading the rows and pasting
them into database tables.

But that is rarely the case in the situations I've encountered.
Often the spreadsheets are in the form of tables (equivalent
to Access crosstab queries) and have to be "ripped" to get
the data into a list format suitable for copying to Access tables.

I never use standalone VB6 but usually what I do is code the
"ripper" in Excel VBA and simply store the output in an
unused area of the work*** or write it out to a text file
in csv format. Then I either copy/paste to the Access table
or import the csv file from within Access.

But VB6 ought to be able to do these tasks with running
either Excel or Access.


Thanks in advance,

Henk

.