> hi all,
> i have problem in importing excel to dbf format using VFP 7.0. I use APPEND FROM excel file TYPE XL8, and i store to new dbf table that has same order and data type with xls,some of date from year 2001 become blank in my dbf table. any idea? Thank You...
Could you check back in Excel if that particular date has been entered as a text string instad of as a date. Dates in Excel or acually stored as the number days since 1899/12/30. If you change the cell's formatting to Number it shouldn't show up as 0.
-Anders