Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append From and Dates
Message
De
17/10/2003 10:20:56
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
17/10/2003 09:10:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00839700
Message ID:
00839748
Vues:
18
>Does the APPEND FROM (a CSV file) command respect SET CENTURY ... ROLLOVER settings?
>
>I am importing data from an Excel CSV file that has dates specified as 8 characters or 10 characters (I have no control over the source of this data). Obviously, the 8 char dates are assumed to be from the 20th century but irrespective of my SET CENTURY ... ROLLOVER settings, the dates are not being converted properly from the CSV into the DBF.
>
>I seem to recall that there are problems with date conversion when using APPEND FROM but, I am unsure whether; a) this is the case and; b) if so, has this been "corrected" in VFP7/8.
>
>Any tips very much appreciated.

Gary,
AFAIK append from (CSV) is problematic. Remove the first line (headers) and then do a delimited type append.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform