Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel - Save As CVS
Message
 
 
To
02/02/2012 14:34:37
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01534335
Message ID:
01534350
Views:
52
>I have been given a bunch of csv file that I need to import into a database. But, when I import them, the dates are not converting. But if I open them in Excel and save them as CSV (MS-DOS) they convert correctly.
>
>To save time, I would like to create a VFP program that would do the SaveAs routine for me. What is the proper Automation procedure to do the SaveAs?

Check Message ID: 1388459

If you get dates as numbers you can covert them using http://www.berezniker.com/content/pages/visual-foxpro/convert-excel-serial-number-date-vfp-date
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform