Import open office scalc file

[aji24]

Hi, i'm trying to import an open office scalc file to microsoft access using:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, strTableName, strPath, True, "Sheet1"

(i'm not sure if acSpreadsheetTypeExcel8 is the right format for open office file). it always give error : "external table is not in the expected format"

can anyone help me how to fix it? it will be great if the solution can also work in microsoft excel :)

thx in advance..

[missinglinq]

I'm not really sure here, but my guess is that your OpenOffice spreadsheet file is saved in its native .SXC format instead of the Excel .XLS format, which accouts for the "file format not recognized" message.

[srinivasreddya]

hi iam looking for the same solution please help me

thanks
cnu