Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append From Excel file with a date field
Message
From
05/08/2003 11:15:52
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
04/08/2003 17:28:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00816630
Message ID:
00816906
Views:
29
Thanks, thats it.

Jerry


>see
>Re: Importing Excel Files - Date Problem Thread #548892 Message #548906
>
>>I'm using VFP8 to Append From an XLS file. This Excel file has a date field formatted as:
>>
>>August 4, 2003
>>
>>I create a VFP import cursor and import as follows:
>>CREATE CURSOR cimport ( mydate C(20) )
>>APPEND FROM myxls.xls TYPE XL8
>>
>>This works except that the date column in my cursor displays as
>>37837 (todays date), instead of August 4, 2003.
>>
>>Is there a function to convert this date format into a VFP format?
>>
>>Thanks,
>>
>>Jerry
Previous
Reply
Map
View

Click here to load this message in the networking platform