Re: How do I import DOS files into Excel?
- From: jessicaannmontagne <jessicaannmontagne@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 27 Oct 2006 09:39:02 -0700
The old database is running on a machine. On Monday I will bombard my IT guy
to try the CSV thing. I will let you know how it does sometime next week.
Thanks so much for you help!!
Jess
"John Nurick" wrote:
Hi Jessica Ann,.
I suppose the first question is, do you have the old database running on
a computer, or do you just have its data files?
1) If you've got it running, the preferred approach is to export the
data from the old program into a common format (e.g. CSV files), copy
these to your Windows computer system (e.g. via floppy disk), and then
import them into Access or Excel.
Even in those days, most database software could export to CSV files. If
yours has no export function, can you get it to print out the data in a
very plain tabular or report format? If your IT guy is on the ball he
will probably be able to redirect what the the program thinks it is
sending to the printer to a disk file; with a bit of work it will be
possible to turn this into something Access or Excel can import.
Partly it depends on how much data there is. If it's just a hundred or
so names and addresses it's probably quicker just to re-type them and
proof-read the result. If there are thousands, it's worth going to some
trouble to avoid re-keying. So yet another possibility is to print the
data onto paper and then use a scanner and OCR software to read it back
into the Windows machine, then import into Access, print out again, and
proof-read.
2) If you have the data files but not a computer that can use them, the
choice is between re-keying the data (assuming you have it on paper) and
somehow reading the files. If this is the case, feel free to email me
examples of the data files (be sure to remove the reversed spam-trap
from my address) and I'll take a shufti and let you know how difficult
that might be.
On Thu, 26 Oct 2006 10:08:01 -0700, jessicaannmontagne
<jessicaannmontagne@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Wow. So, I'm guesing we don't know if this is possible then?
Would I be better off trying to just manually enter the info into a new
database?
The IT guy here said that he tried to convert it to Microsoft, but it is
only compatible with Window's 98.
"Klatuu" wrote:
True enough, but I did start working with DOS database products in about
1986. DBase III, FoxBase, Clipper, Quicksilver, Paradox, and later FoxPro
dos versions from 1.0, but PDE: First Choice is one I missed.
I tried googling it, but did not find everything.
What I did find is that the file extension for the data files is .fcd, but
no info on the file format. Apparently it was produced by a company named
SoftKeys International which appears to be a German company. I tried
www.Softkey.com and working through that came up with this info trying to
find technical support on their products.
Mindscape UK Ltd
41 Basepoint Business Centre
Metcalf Way, Crawley
West Sussex
RH11 7XX
Hope this will give the OP a place to start looking.
"John Nurick" wrote:
On Thu, 12 Oct 2006 08:28:03 -0700, Klatuu
<Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I've never even heard of PFE. Can you determine what the file format is?
You must have been working on big metal back then! PFE: First Choice was
a fairly common lightweight database program. IIRC it goes back, like
dBase, to the days before DOS.
I never used it seriously but am pretty sure it could export to text
files or some other standard format (DIF, perhaps). If not, a web search
may reveal some conversion software. Failing that, the file format is
likely to be fairly simple (much like DBF and nothing like MDB) so given
a file and sight of what the data's meant to look like it shouldn't be
too hard to write one's own converter.
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
- References:
- Re: How do I import DOS files into Excel?
- From: John Nurick
- Re: How do I import DOS files into Excel?
- From: John Nurick
- Re: How do I import DOS files into Excel?
- Prev by Date: Re: Exporting more than 65'536 rows from Access to Excel
- Next by Date: Re: How do I display number field in Access?
- Previous by thread: Re: How do I import DOS files into Excel?
- Next by thread: RE: Err 3061Too Few Parameters
- Index(es):
Relevant Pages
|
