Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing Dates from EXCEL
Message
De
08/10/2002 02:32:58
 
 
À
26/09/2002 16:03:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00704949
Message ID:
00708632
Vues:
10
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform