Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wrong Years
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01333160
Message ID:
01333193
Views:
10
I'm still confused. Where VFP comes in the picture?

>CSV. But when I open the csv file with Excel, that's the format the date fields are in.
>
>>I'm confused. Are you importing from Excel or from CSV file?
>>
>>>The difference was that the date field in excel was stored as a date instead of text.
>>>
>>>>>When importing from a csv file, the year portion of the dates are distorted. Example: 01/01/2009 come up as 01/01/0009. Is there a fix for this?
>>>>
>>>>Works fine for me in the test below. How yours CSV is different?
>>>>
>>>>TEXT TO lcStr NOSHOW
>>>>"Date","String","Int"
>>>>01/01/2009,"String1", 15
>>>>12/25/2008,"String2", 23
>>>>
>>>>ENDTEXT
>>>>
>>>>STRTOFILE(lcStr, "temp.csv")
>>>>
>>>>CREATE CURSOR Temp (fld1 D, fld2 C(30), Fld3 I)
>>>>APPEND FROM "temp.csv" CSV
>>>>LOCATE
>>>>BROWSE NOWAIT
>>>>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform