Book a Demo

Author Topic: Importing From Access 2003  (Read 2699 times)

prussell

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Importing From Access 2003
« on: April 28, 2009, 09:36:00 am »
I am trying to import an Access 2003 database. When I click Import, the list of tables is displayed. I choose Select All then Ok. I get the following error:

Unrecognized database format 'C:\db1.mdb'

The same happens for Access 2000, and 97 formats.

This does import from Access?

thx
patrick

juhi

  • EA Novice
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Re: Importing From Access 2003
« Reply #1 on: April 28, 2009, 10:22:50 am »
Hi Patrick,

Please configure EA to use JET 4.0 Engine. To do so, goto EA Tools | Options | Check "Use JET 4.0 Engine - requires restart" checkbox. After that, restart EA and try to import it again. Also please make sure that, nothing is entered in Schema / Owner text box in Import DB Schema dialog box.

Thanks,
 :) Juhi
Sparx Systems Pty Ltd

prussell

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Importing From Access 2003
« Reply #2 on: April 28, 2009, 11:44:09 am »
Thanks Juhi.

patrick