>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:
1388459If 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--