Quote:> >>I have an old database program that I purchased from
> >>Hoyle and Hoyle Software in 1983 (Yes, that's
> >>right...1983) called General Database version 2:02. It
> >> suited my needs fine until recently. Now I want to
> >>convert over 10 years worth of accumulated data to
> >>dBASE. However, dBASE (or any other database program I
> >> tried) cannot recognize the format. There must be a
> >>way to keep this data without re-typing all of it ...
> >>but I don't know how. Does anyone know of any filters
> >>that will allow me to convert non-dBASE data to dBASE
> >>data...or even to ASCII???
dBase IV can read several types of data files, but it needs to know what
type of file it is reading: ASCII, delimited txt, system data format
(extension SDF), document interchange format (extension DIF), symbolic link
format (extension SYLK), PFS:FILE format, RapidFile format (extension RPD),
Lotus format (extension WK1). You will need to know which type of file the
data is saved in, or be able to save it in a form that dBase can read. If
none of the file extensions look right see if you can decide how the data
was stored by looking at the file from DOS. The programs manual should
also tell you how it is saving the data, on some back page in really small
ASCII are just characters and spaces (like a text file).
Delimited format files have the fields separated by a specific aharacter
(like a quotation mark and or camas) or a space (blank delimited). The
most common character delimited format is to put quotation marks around the
data in each field, separate the fields by commas, and the records by
Many spreadsheet programs store data in SDF format, where the fields have a
fixed length (number of spaces) and records are separated by a carriage
return. The raw data looks much like a table, with the fields forming
columns. A SDF formated file could also be called a: flat file,
fixed-length file, or DOS text file.
Microsoft developed SYLK format for data exchange between their graphic,
spreadsheet and data base programs.
DIF format has been used by several spreadsheat and database programs, it
looks similar to the delimited file format.
WKS and WK1 formats are Lotus/Symphony product file exchange formats.
Most database programs can save data as ASCII, delimited or SDF formated
files. Try those file types first.
To transfer data into dBase you must use the APPEND command. That means
you need to have a database already setup for the transfer. Make sure it
has the same number of fields as the old database does.
After setting up the new database go to the dot prompt and type in:
APPEND FROM filename TYPE type
where filename = the name of the file to be transfered
and type = one of the dBase acceptable formats:
*the WITH parameter lets you designate the character used the defalt
character is the question mark*
Use a small data set to test the various file types. If you indicate the
wrong type of file you will either be told dBase can't transfer the data or
you will get junk.
If none of these formats works see if you can open the file in a
wordprocessing program. I have found that Microsoft Word is a good go
between for several types of files. It adds an extra step to the transfer,
but still beats reentering the data.