Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel - Save As CVS
Message
 
 
À
02/02/2012 14:34:37
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01534335
Message ID:
01534350
Vues:
51
>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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform