Exporting Access 2000 mdb to Dbase 5 using docmd.transferdatabase VB6
Posted on 2003-03-11
I am facing a problem while trying to convert a MDB table into dbase using VB 6.
[I use win 98]
I have a mdb named customer at c:\
in which there is a table - maincustomer
i want to export data and struc. using docmd.transferdatabase into dbase 5 format.
i use vb 6 click event.here is syntax.
docmd.transferdatabase acexport, "dBASE 5","c:\maincustomer", actable,"maincustomer","main.dbf"
I tried "DBASE 5.0" / DBASE III / DBDBASE IV. But all failed
I receive error that either path is incorrect or not connected to server. I am working on standalone so no question of server and my path is also perfect. I also receive other error that "dbase 5 is not installed type". I tried to look for solution in MSDN also but cannot find it. Please help.
When I tried "dBASE III" - it "dont" give any error but it also dont give any result. I tried same thing in Access through Macro but there also I get error that the path is incorrect.
Please help me out.