Hi Govind, At last check, MS Access (if you have it) can still import and export both DBF and CSV files.
Older Excel versions (2003 and older I believe) can import/export from DBF natively. CSV is still supported. Also, free OpenOffice and LibreOffice have that capability. It should be possible to do the same from VBA in Excel using ADO, but don't have the code for you. A search turns up some converters that seem to be available for free: http://www.alexnolan.net/software/dbf.htm - freeware http://sourceforge.net/projects/dbfconverter/ - open source http://sourceforge.net/projects/dbmt/ - open source http://www.vlsoftware.net/exportizer/index.html - no-cost version? https://www.libreoffice.org/ - open source http://www.openoffice.org/ - open source Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Govind Mori Sent: Wednesday, March 28, 2012 3:29 AM To: excel-macros Subject: $$Excel-Macros$$ how to convert dbf III (Dos Based Fox-pro 2.5) file to CSV file Dear Members I m new to this group, Please help me to easy way of converting DBF file to CSV file Thanks Govind Mori -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com