I have tried, I get a handle but the query fails. I think the sqlexe does not like the name "Sheet1$" or the real sheet name (all the sheets are named) in the query string. I cannot successfully execute the query. I get a handle, so the connStr is good. Any ideas?

>Check Importing data from a Microsoft Excel 2007 workbook using Visual FoxPro 9.0
>
>>
>>We get an Excel 2007 file with 5 sheets of different accounting data. I need to put each of them into a DBF. Since MS deprecated the Excel saveas DBF3 or DBF4, I have to find another solution. I have made saving to a CSV file work for data I know the structure of. For data I do NOT know the structure, I thought using XML would be straight forward using XmlToCursor. But once again, MS has every fileformat for the Excel saveas method except XML. If there is a better solution I am all ears. I do not know about XMLSS, but will check it out. Do you have any tips to shorten my learning curve?
>>
>>I am very new to the Office 2007 automation process. I have several solutions using Office 2003 and before, but 2007's object model is confusing. I have not used XML but for one app. I hope the solution is NOT building the Excel to XML line by line. I feel that would be very primitive compared to the object models available. We are not using .Net for a solution, only VFP and the Office object model.
>>