Export Table like database (mdb) to DbaseIV Is't possible?

[regis]

I would like to export data format (mdb) to table DBaseIV

How can I do That ?
thanks
Redg

[Iouri]

For MS Access
=============
INSERT INTO Table1 IN 'ExternalDatabasePath1' SELECT *
FROM Table1 IN 'ExternalDatabasePath2';
where externaldatabasepath1 & 2 are something like c:\databases\db1.mdb & c:\databases\db2.mdb
(INSERT INTO Table1 SELECT * FROM Table2 IN 'c:/aaa/bbb/Database.mdb')

Database, which engine is understood by VB
=====================================
You can also add a type to the end of the IN clause such as "dBASE IV" e.g.,

INSERT INTO Table1 IN 'ExtDB' 'dBASE IV' SELECT * ....

'Another example insert to external db
Dim db as database
Set db = Workspaces(0).OpenDatabase(app.path & "Biblio.mdb")
db.execute "SELECT * INTO [dBase III;DATABASE="C:My Documents].[test] FROM [authors]"

By using the brackets and dot operator, you get a completely proper output in the ISAM database type of
your choice. Also, if you choose Text as the database type, the statement creates a Schema.ini for you
automatically, or adds a new section for your new data file to a Schema.ini already in the path folder.


Iouri Boutchkine
iouri@hotsheet.com