Opening Borland engine database in Access.

Question

Is it possible to open a database created with a Borland engine in Access? I keep getting an error message: "External table is not in the expected format." Does anyone have a solution to opening this database up? Just need to be able to grab the data and drop it in an Excel sheet.

Answer 1

Instead of trying to open the database in Access, you'd better use an application to directly export the content to an Excel sheet. There are many applications created for this type of job and it's more easier than finding ways to properly import the database in Access. It's a tedious and complicated. For example, Exportizer is an application that can handle the BDE database to export it to XLS file format.