>How do you use the wizard to import Dates from Excel? I have copied the EXCEL Date column and formated it to one of each of the following: Text, Date, Numeric and imported them using the Import Wizard. The ECEL date of 09/06/02 comes into VFP as 08/22/02 as an example no matter what I do. What is the secret?
For Excel5, the value is Numeric: Carry the different between the date and
{^1899/12/30}
What you can do:
IMPORT FROM abc.xls TYPE XL5
SELECT abc.a AS ORDER_ID, {1900/1/1}-2+abc.b AS ORDER_DATE, .... ;
FROM abc WHERE RECNO()#1
INTO TABLE dbfABC
Since the First Record is Field header information, you don't need it at all.
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.