mojick
asked on
Exporting Access 2000 mdb to Dbase 5 using docmd.transferdatabase VB6
Hi
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","ma
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.
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","ma
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.
Sorry, skip the first question. Just saw the A2000 in the question title.
As to the second, that means you should be up to SP5. Download and install if your not.
Jim.
As to the second, that means you should be up to SP5. Download and install if your not.
Jim.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
HI MMARTEL
Your syntax worked. My problem is solved. I had to make little addition to your code. I used
appacc.docmd.opentable "table1"
in which i gave name of the table to export.
So thanks .
Your syntax worked. My problem is solved. I had to make little addition to your code. I used
appacc.docmd.opentable "table1"
in which i gave name of the table to export.
So thanks .
Hi mojick,
This question has been abandoned and needs to be finalized (103 days since last comment).
You can accept an answer, split the points, or get a refund. Go to
http://www.cityofangels.com/Experts/Closing.htm for information and options.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
nexusnation
EE Cleanup Volunteer for Microsoft Access
This question has been abandoned and needs to be finalized (103 days since last comment).
You can accept an answer, split the points, or get a refund. Go to
http://www.cityofangels.com/Experts/Closing.htm for information and options.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
nexusnation
EE Cleanup Volunteer for Microsoft Access
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, points to mmartel
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
1William
EE Cleanup Volunteer
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, points to mmartel
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
1William
EE Cleanup Volunteer
Have you updated your JET environment with the latest SP's?
Jim.