need to convert CSV file to DBF file from MS-Access 2007 through Macro

Question

I need to convert CSV file to DBF file from MS-Access 2007 through Macro Please Help me! I am stuck with it. I want to automate it,as its a daily need in my firm I need a button that whenever i click on it,it picks up the CSV file and convert it into DBF file I Have the idea,what all i can do but i dont know how to do it.

Answer 1

You can't. Access 2007 knows nothing about DBF files.

One option is to get hold of an Access 2000 copy. Then export your data to an Access 2000 format mdb file, and open this in Access 2000 and export as DBF.

Edit:

This answer claims to work with Access 2007:

Export MS Access tables as dBase 5 through VBA

Also, I tested that with Access 2000. It doesn't know dBase 5, but dBase IV works for me:

DoCmd.TransferDatabase acExport, "dBase IV", "c:\test", acTable, "TestTable", "DBTable4", False, False

Note that the file name is limited to eight characters.