>>>Thank you, Tore. I will read these resources as I have to convert a large excel into a SQL database and I only know of how to do it via VFP.
>>>
>>>>
http://www.foxpert.com/docs/excel.en.htm>>>>
http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx>>>>
>>IMHO, you don't want to put VFP in the middle, I'd rather go directly from Excel to SQL database. Start from trying Import/Export wizard, most likely it will be sufficient.
>
>Do I have to have a table in SQL to import from excel? If so, it would be a pain since I have to manipulate the data from excel a lot before it goes into a couple of tables in SQL. And "manipulating" in VFP is much easier.
No, you don't have to create a table, you can create it on the fly based on the Excel file.
If it's not broken, fix it until it is.
My Blog