>Nick,
>
>>Maybe I should automate saving it as the correct version in excel
>
>That'd certainly be a way to do it, provided Excel is installed on the machine running the process. The ODBC driver doesn't require Excel to be installed.

Hi Dave

if I have

oExcel = CreateObject("Excel.Application")
oWorkbook = oExcel.Application.Workbooks.Open(lcFilename)
oWorkbook.SaveAs("j:\global\ss\correct.xls", 56) && xlExcel8

why do I get "Unable to get the SaveAs property of the workbook class.


Update it doesn't like the 56 so I need to find the correct filetype parameter.
2nd Update 39 is the value I want.

I hate automation :-(

Thanks