Exporting Access DB to DB III thru VB? 
Author Message
 Exporting Access DB to DB III thru VB?

I am developing a VB app, in which I would like to use the flexibility of
the Access DB, but would like to have the ability for the data to be
exported to a DB III or IV format, so other Apps can use the data (since
Access DB format is not widely found as an import option).  Anyone have
any ideas??


Fri, 08 Aug 1997 03:22:34 GMT  
 Exporting Access DB to DB III thru VB?

Quote:

> I am developing a VB app, in which I would like to use the flexibility of
> the Access DB, but would like to have the ability for the data to be
> exported to a DB III or IV format, so other Apps can use the data (since
> Access DB format is not widely found as an import option).  Anyone have
> any ideas??

Set up a dBase ODBC datasource, and use the standard CreateTable etc.
to create your export files as tables in that datasource.

--

DBM Database Marketing Oy, Helsinki, FINLAND    " Q: What is the opposite
Tel: +358 0 605 900, Fax: +358 0 605 991         of information? "



Sun, 10 Aug 1997 18:22:54 GMT  
 Exporting Access DB to DB III thru VB?

Quote:

>  I am developing a VB app, in which I would like to use the flexibility of
>  the Access DB, but would like to have the ability for the data to be
>  exported to a DB III or IV format, so other Apps can use the data (since
>  Access DB format is not widely found as an import option).  Anyone have
>  any ideas??

In your VB app, you would have to declare two ODBC connections.  One for
Access and the other for dBase.  So basically you'll be moving the data from the
Access dynaset to the dBase dynaset.

However, if all you're looking is to convert the Access database into the dBase
format, I think you can do an export from the Access program.  dBase should
be one of the export options.

Andrew



Sun, 10 Aug 1997 22:07:34 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. export data from one access db to same db on another machine using vb6

2. Converting Access 2.0 DB to Access 97 DB in VB code

3. STILL NEED HELP: INITIALIZING WAV FILE HELD IN ACCESS db THRU VB

4. STILL NEED HELP: INITIALIZING WAV FILE HELD IN ACCESS db THRU VB

5. Importing into an Access DB thru VB code

6. Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

7. Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

8. Exporting Access MDB to DBF - DB via VB?

9. To Cláudio Avólio Rodrigues (DB III files in VB 3 Pro)

10. Convert Access 97 db to Access 2000 db in VB6

11. Attaching Access Db files to Access DB

12. VB3 using Access 2.0 db thru ODBC

 

 
Powered by phpBB® Forum Software