>>>>To make our application work with Excel 2007 the IMPORT command doesn't work anymore and reading MS article
http://support.microsoft.com/default.aspx?scid=kb;en-us;949529 we want to go with the ODBC route and the SQLEXEC but the article states to download "The 2007 Office System Driver: Data Connectivity Components package" I've never downloaded that and the Excel driver works for me. Does this get installed with Office 2007 by default or do I need to make this a prerequisite for our application if you want to use Office 2007?
>>>
>>>Drivers get installed by Excel installation and you can also install on demand. I use OLEDB drivers and happy with it. Maybe you should prefer over ODBC connection too. Check this if you want:
>>>
>>>
http://www.foxite.com/archives/0000153776.htm>>>
>>>Cetin
>>
>>Thanks but I really need it in a FoxPro table and from my experiences using ODBC to get directly into a VFP table is a lot faster then ADO to VFP table.
>
>That is true, ODBC might be slightly faster and you might gain less than 200 milliseconds maybe. However it would worth to see if you can get ODBC with Excel working. I haven't seen yet.
>Cetin
Works for us an example is on MS site that I listed above.
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers