>>>>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.
I will try it; should be interesting exercise. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham