Re: Using Excel data in a VB6 database


"Duane Arnold" <"Do forget about it"@PleaeDo.BET> schreef in bericht
news:AvAKg.5485$xQ1.2752@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

...............

ok thanks for your comments, I think I understand.

I did use importing comma-delimited files in Access. So I'm familiar with
that.

Now I'm trying to connect my VB6 to an Excel file to use this excel file as
a database.

These are the database-engines listed with VB6:

1 - Microsoft ISAM 1.1 OLE DB Provider
2 - Microsoft Jet 3.51 OLE DB Provider
3 - Microsoft Jet 4.0 OLE DB Provider
4 - Microsoft OLE DB Provider for Indexing Service
5 - Microsoft OLE DB Provider for Internet Publishing
6 - Microsoft OLE DB Provider for ODBC Drivers
7 - Microsoft OLE DB Provider for Oracle
8 - Microsoft OLE DB Provider for SQL Server
9 - Microsoft OLE DB Simple Provider
10 - MSDataShap
11 - OLE DB-provider voor Microsoft Directory Services

Only database engines 4 and 11 accept Excelfiles.

Using a 'Data' object or using 'DataEnvironment' connecting works but ONLY
at DESIGNTIME!. So it seems to be impossible to connect another Excel file
as a database to the VB6-application during runtime.

As in Borland Builder C++ one could easily redirect the 'DataSource' ('Data'
inVB6) property to another file to be used as database.

But maybe there's still some trick to manage this.

Keeping searching....

regards,

Henk


.

Relevant Pages

  • Re: question about mining external databases and exporting mining models into pmml
    ... have a provider that we can work with (OLE DB provider or .Net data ... I think Oracle has both an OLE DB provider and a managed ... On the second question: models' PMML may be exported with a statement like: ... database on sql server database engine. ...
    (microsoft.public.sqlserver.datamining)
  • Re: question about mining external databases and exporting mining models into pmml
    ... have a provider that we can work with (OLE DB provider or .Net data ... I think Oracle has both an OLE DB provider and a managed ... On the second question: models' PMML may be exported with a statement like: ... database on sql server database engine. ...
    (microsoft.public.sqlserver.datamining)
  • Re: MS Access driver
    ... How about Microsoft Jet 4.0 OLE DB Provider? ... There have been some changes in Access forms stored in the .mdb file but Ole db ...
    (borland.public.delphi.database.ado)
  • Cant query linked Access database specified by UNC
    ... I link Access database to sql server 2000 with ole db 4 provider; ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ...
    (microsoft.public.sqlserver.security)
  • Client-Server Database Application - Remote Connection
    ... I make a MS Access database and a ODBC DSN on server by my site control panel, ... I think that, i need a proper OLE DB Provider for remoting connection by ADO, but in my OLE DB Provider list does not exist any proper provider. ...
    (borland.public.delphi.database.ado)