Dataflex to Access

[nq]

I have an old DOS based database in Dataflex 2.2 that I want to import into Access. I know nothing about Dataflex. Does anyone have any ideas about how I can export/import the Dataflex data into Access?

I don't need all the data, just selected bits, so exporting to csv or similar is fine. I don't have an ODBC driver for Dataflex either.

Nigel.

 

[OnTheFly]

I have never seen or used Dataflex myself but I do a lot of data transfers from other programs. I would suggest you try an Export from within the Dataflex program itself to see if you can extract the data that way into a file type that Access would recognize. Usually you would do this through a programs reporting module.

I don't know if that will work but it is a shot.

Hope this helps.

OnTheFly

 

[nq]

Thanks for the suggestion. Unfortunately there is no easy way to do this apart from starting up a DOS machine and finding a utility to capture LPT1 to a file. I tried this but it was not very good - some reports worked, others didn't. I think the original programmer did some nasties with the programming.

Nigel.

 

[VOORSPRONG]

Nigel,

DataFlex comes with a query tool called DFQUERY. At least that is the name in the 2.3 product. I worked in 1986 with the 2.2 product but don't recall anymore if it already had that name. If not it was simply named QUERY. If you start this tool you can select the columns and records via a simple point-and-shoot process. One of the export formats is CSV (comma seperated values).

There are two ODBC drivers for the DataFlex database. The product names are FlexODBC (

http://www.flexquarters.com)

and Connix (

http://www.connix.com).

However they will not work on a 2.2 database format, they will support the 2.3, 3.0 and 4.0 database formats.

You wrote that you want to move the DataFlex system to Microsoft Access. Do you know that there is a Visual DataFlex product available and that with this product you can keep a big part of the business logic put in the program in all the years instead of redesigning/rewriting it completely in another language/environment. Visual DataFlex will not be able to read 2.2 databases but you can convert them to the newer level quite easily. Visual DataFlex can also access the Microsoft Access database format if you want to move to a different database format. If you want to take a look at Visual DataFlex go to

http://www.visualdataflex.com