
Extraction of data from Clarion 2.1 for DOS to Access 97
Quote:
> Hi,
> I'm responsible for year 2000 compliance in community college in Montreal.
> I've learned very lately than one of our departerment is using an
> application written in Clarion 2.1 for Dos (1983). The departement that used
> this application dont have the source code anymore neither the developping
> environment. I've got only the files and the application executable.
Benoit, There are two methods I can think of - one a fairly inexpensive
one - mostly your time, but not necessarily the results you might expect.
There were some Clarion DOS utilities that you might even have -
CCVT.EXE - Convert Clarion .DAT files to dBase
One of the Major problems is dates
IF you had the file definition (extension usually ended in .CLA, but
since it's a text file, could be named anything), you could use another
Clarion utility - CFIL.EXE - reformat the date fields using the file
definition, then run CCVT.EXE
Also, since these are old DOS utilities, you need to run them in 8.3 safe
named directories, such as C:\Clartemp
Maybe someone can give a link to a public area where these old
Clarion utility files can be downloaded.
More expensive, but can convert Clarion .DAT files and no date problems -
Data Junction
Vendor Name - Data Junction Corporation,
Data Junction
Internet Link - http://www.datajunction.com/
Dave
--
From Encourager Software - Dave Troxell,
Author of Product Scope 32 Bookmarks -
Profile Exchanges - Clarion Third Party, Clarion Application, Newsgroup -
Email, HTML, PRO Music USB, and Search Engines
http://www.encouragersoftware.com/