Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

i have a problem with my script for convert GDB to Excel.

  if s=='xls':
        writerXls= FMEWriter("XLS_ADO")
        new_schema = export + "Excel\\" + filenameGDB+  ".xls"

        while reader.readSchema(schemaXls):


The creation of my Xls works but the logger of FME tell me : MS Excel Writer: Connection failed. Connection string Provider=Microsoft.Jet.OLEDB.4.0;Data Source=null;Extended Properties="Excel 8.0;HDR=YES"'. Provider errorThe table is not in the expected format.' Failed to open writer

But the logger tell : MS Excel Writer: Closing `C:\Excel\test2.xls' . Write operation complete
The code is in Startup Python Script.

Why ? Thanks

share|improve this question
It is not FME it is Excel - please read -… – Mapperz Jun 15 '11 at 14:47
It's very strange because the same code in PythonCreator works very well !!! – user3120 Jun 15 '11 at 15:16
I think the more relevant question is why you are using a script to convert GDB to Excel? FME will let you do this much more easily in a workspace - then you can run that workspace programmatically if you need to, passing in parameters as required. Check out my blog post on the subject at: – Mark Ireland Jun 15 '11 at 16:19
Because it's a dynamic workbench and it's very fast with Python... – user3120 Jun 16 '11 at 2:25

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.