Converting Excel to DBF

[breezett93]

My Google searches only brought up websites trying to get me to download their software to convert it for me. I would prefer a more secure way through FoxPro.

I also tried exporting through Excel, but I couldn't find a .dbf format.

Thanks.

 

[NasibKalsi]

I was using Excel 2003 and save as dbf until MS removed the option from the newer versions.

Now I create DBF using automation.

Logic Explanation:

Create a table with at least 4 fields
XLSNAME, XLSCOL, DBFCOL, FTYPE

XLSNAME: if there are x different dbf file having different field names, assign each with it unique name
XLSCOL: First row is the fileds names.
DBFCOL: Equivalent DBF Field Name. DBF Filed name is limited to 9 chars.
FTYPE : Field type, Char, Numeric, Date, ++

Data Example:
FILE1 DATEOFBIRTH DOF D
FILE1 FIRSTNAME FNAME C
FILE1 CITYOFBIRTH CITY C
FILE1 CITY_OF_BIRTH CITY C
FILE1 CITY CITY C
FILE1 AGE AGE N


Go through the XLSX/XLS file and do validation on each value.
Make sure you check for NULL and BLANK
Check the field type and convert to the proper type if it is not.
replace the target table with the proper values in their respective fields.

You can even list all the fileds on the form preceded with a CheckBox and user can tick the ones it requires.
You can add a CommandButton to select the XLSX/XLS file.

 

[clipper01]

This problem was recently covered and a superb solution provided by the incomparable Mr Vilhelm-Ion Praisach. I've used his utility to import xlsx files of about 30,000 + lines , no problems.

Thread reference : Import to Memo Fields 2 thread184-1755524

Usage is as simple as

Importfromxlsx("MyExcelFile")

Appendfromxlsx("MyExcelFile")

The first one creates the table, based on the first imported row of the spreadsheet (tries to mimic VFP's import command).
The second one append the spreadsheet content to and existing table (tries to mimic VFP's append from command)

 

[vgulielmus]

Very nice words, thank you clipper01

Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

 

[Olaf Doschke]

I agree what you still do actively for VFP in your blog is beyond compare, Vilhelm-Ion.

Bye, Olaf.

 

[vgulielmus]

Thank you, I am overwhelmed

Respectfully,
Vilhelm-Ion Praisach
Resita, Romania