Exporting ACCESS files in Dbase III format through VB6

[vinodi]

Hi,

I know the subject line is a little long. Well guys here is my problem.

I have developed an application using VB6 with ACCESS 2000 as backend. One of the tables existing in Access needs to be exported in Dbase III format for further processing ( on an everyday basis ).

I further know that this can be achieved by me by using the File - Save As command and then choosing Dbase III from the drop-down list box present in the subsequent dialog box. However, for an ordinary user I do not want him to open the backend and perform this task.

Therefore I want to know whether it is possible to perform the same task through VB by coding some routine in the front-end which will enable the user to pick up the table from the back-end and export it in Dbase III format.

Thanks in advance

Vinodi

~~The only place where SUCCESS comes before WORK is in the dictionary~~

 

[snehakevin]

Connect to both the sources... ie. Access and Dbase III (I have used fox pro db)... read from access table and write to the dbase table.....

I have not worked with DbaseIII...
I have done this with foxpro dbf.

open recordset in access
one by one write into dbase III table using adnew.