Thanks all members for taking notes of my query, I will try at my level and
come back to u
thanks once again.
Govind .Mori
On Thu, Mar 29, 2012 at 11:46 AM, Asa Rossoff <a...@lovetour.info> wrote:
> 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 <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
>
--
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
