Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Modifying Excel Import Procedure?
Message
From
11/04/2002 10:39:48
 
 
To
11/04/2002 09:51:39
N. Lea
Nic Cross Enterprises
Valencia, California, United States
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00643706
Message ID:
00643744
Views:
6
Import the xls to a temporary cursor using append from. The cursor should have two EXTRA columns of type "date" which will remain empty after append.

Replace the values in the extra columns with char values converted to date.

Append from the temporary cursor to the final table

The extra columns should have the same name as the date columns in the final table.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform