Old Database to Access or SQL

[Bobbo70]

Hi All;
How can I use FoxPro (.dbf) database in DOS to read its data and save it to the new RDBMS Database like Access or SQL or at least save it in Excel sheet for example.

[Wen Lie]

Yes you can.
Open 2 connection in VB. One for your foxpro .DBF, one for your Access / SQL database.

Read your record from connection I, then write the record at connection II.

[Wen Lie]

sorry I don't know how to reply the PV msg =p~

Quote from your msg :
===========================================
Hi Wen;
Would this work for the DOS database (.dbf)? And how can I
open it in Excel worksheet?
===========================================

Actually, if you use VB coding to transfer your .DBF to your excel sheet, yes you can. Though your .DBF is a dos database.

or, in simple way,....
if you need to transfer all records in your .dbf to an excell sheet, you can just open your .DBF at your Ms-Excel.
Click open toolbar, then change your file type (to open) to All Files (*.*) then search your .DBF to be opened at your excell sheet.

[Wen Lie]

Hi Wen:
Thanks a lot to your reply I'll try it. I knew that Excel open a database files and (.dbf) but some others try to open this .dbf for DOS into Excel and the arabic from Elmosaed appear as strange characters this is the main problem I'm sorry I forget to mention this problem.

actually if the .DBF file is not corrupt, you can successfully open the .DBF in MS-Excell.

but one thing you should also consider is, Ms-Excell has its limitation on row of records. Since max of rows in excell only 65536.

how many records do you have at your .DBF file ???