ODBC Reverse engineering problem (Access / Excel)

[tsaltd]

… I cannot reverse engineer Access tables and Excel spreadsheets into Classes in context of Data Modeling diagram  (Excel wks was created by exporting the Access tables ).

I get the following errors …..

Excel worksheet .xls  (ODBC Driver specifies Excel 2000 - 3 ) ....

"ODBC Driver Manager does not support the Function"

Access Table -- .mdb (

"Unrecognized Database Format"

Error dialog windows both have "EA" title and are modal over parent "Reverse Engineering Progress" / "Current Action"

Both of these data sources open correctly using MS Query ODBC connection.

EA version is 7.1.830 ... single user version ( DB version 4.01)

hope this is enough info to get response from someone who has run into this before ... and may have a fix.

Thanks,

Steve

[joneil]

I am running into the same problem, doesn't look like you got any response back yet.  Have you come up with anything as a work around?

Thanks,

Joe

[hd]

Go to ... Tools | Options and check Use JET 4.0 to import Access 2000/2003 database objects.

[joneil]

I am getting an error message "Database cannot be opened". There is not security on this database and I am able to open it without a problem through Access and I have made sure that I do not have the database open in Access prior to attempting the import.

Any suggestions?

Joe