Govind,
Correction. I seem to have been mistaken. File, Open. Change the file
types ("Excel Files") to "dBase Files (*.dbf)". Still an option in Excel
2010.
Then Save as, change file type to CSV.
If that import doesn't work as desired, you can try Data>Get External
Data>From Other Sources.
>From there there are multiple avenues that could work.
1. From Microsoft Query - use this to import using ODBC. "dBase Files" will
probably be listed as one of the ODBC data sources.
2. From Data Connection Wizard, then Other/Advanced. The Jet 4.0 and I
think Office Access Database Engine OLE DB Providers should work.
Asa
From: Asa Rossoff [mailto:a...@lovetour.info]
Sent: Wednesday, March 28, 2012 4:44 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ how to convert dbf III (Dos Based Fox-pro 2.5)
file to CSV file
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
