Export Paradox files to Access

[locker3]

I have large Paradox files that I wish to export to Access so they can be read by Access users on the web. My current version of Paradox (7) does not offer an option to export to Access. My earlier solution was to export to Paradox 5 format which was readable by earlier versions of Access. But I'm told that Access 2003 will not read those files. Does anyone know if Paradox 12 offers an option to export to Access? (I would like to know before I invest in more software).
Ed Jones

 

[TonyMcGuire]

No, there isn't any modern version of Paradox that has an export feature to Access.

However, with ODBC you can directly copy a Paradox table into a preexisting .mdb file AS an Access table. The .mdb can even be empty.

Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[TonyMcGuire]

Just in case you need some help using ODBC to do the Paradox->Access bit, below is a link to an article that explains it in step-by-step fashion:


"Using ODBC Data Sources" by Liz McGuire

http://www.thedbcommunity.com/index.php?option=com_content&task=view&id=70&Itemid=44

Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[Kliot]

Reverse your thinking, Import your Paradox table into Access. Access will import a Paradox table.

 

[TonyMcGuire]

Import" directly, or through an ODBC driver?

Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.