Exporting Access DB to DB III thru VB?

Exporting Access DB to DB III thru VB?

Post by Darren Pamat » Tue, 21 Feb 1995 04:22:34



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??
 
 
 

Exporting Access DB to DB III thru VB?

Post by Ebbe Jonss » Thu, 23 Feb 1995 19:22:54



> 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? "

 
 
 

Exporting Access DB to DB III thru VB?

Post by Andrew Kuo, LCN » Thu, 23 Feb 1995 23:07:34



>  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