No real solution - just a "work around..."

** In Feb 2005, client upgraded to Office 2003
** Since then we are unable to import their data
** Here we open that xls file and save it as another 
** file - that seems to work - don't know why...		

** first we check to see if this file is already imported

lcImportFile = "\\svrlr02\ftp\users\Client\" + trim(laImpClientFiles[i,1])
lcImportFile2 = "W:\microcomp\import\Client\" + trim(laImpClientFiles[i,1])
lcImportBakFile = "W:\microcomp\import\Client\Bak\" + ALLTRIM(STRTRAN(UPPER(laImpClientFiles[i,1]), "XLS", "BAK"))
					
IF !FILE(lcImportBakFile)

        loExcel = CreateObject("Excel.Application")
	loWorkbook = loExcel.Workbooks.Open(lcImportFile)
	loWorkbook.SaveAs(lcImportFile2)
	loworkbook.close
					
	RELEASE loExcel
					
ENDIF
										
DELETE FILE(lcImportFile)

Hope that helps...

>Did you ever find an answer to this one??! running into the same problem myeself!
>
>>We have been importing from Excel for months now without a problem. The client from which we receive the Excel files just upgraded to Office 2003. Now when we try to import the Excel files we receive from them, we get a bunch of garbage - nothing is really readable. If I open the same Excel file in my version of Excel - which is also Office 2003 - and just save the file, the import works fine. Anyone have any clues as to what's going on?
>>
>>Thanks.