>You have 2 choices:
>
>
At another location specify 97-2003 format for Save instead of default. If it's Excel 2007 the format should be 5.0/95.
>
> Use automation to re-save spreadsheet in desired format.
>
>>I am trying to import from an excel file into a cursor that i have created. I use the following
>>>>mremitfile = GETFILE('xls',' ','OK',0,'Select the file')
>>...
>>APPEND FROM (mremitfile) TYPE XLS
>>
>>and that works fine once the file is in 97-2003 format. the kicker is that i export this file from another location using OLE and it saves as an xls file, but if i try to import this file without saving as 97-2003 i get an error saying that the file type is not a valid xls. i would like to be able to import the file without getting the user to save as first
>>~M
One more choice.
Instead of IMPORT or APPEND FROM ... use OLE DB or ODBC to get data :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.