Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append From and Dates
Message
From
17/10/2003 10:20:56
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
17/10/2003 09:10:11
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00839700
Message ID:
00839748
Views:
19
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform