[Date Prev][Date Next][Subject Prev][Subject Next][
Date Index][
Subject Index]
Re: XYWRITE digest 2295
- Subject: Re: XYWRITE digest 2295
- From: Bill Mallon bmallon@xxxxxxxx
- Date: Sat, 18 Jun 2005 00:21:11 -0400
Actually, Excel is a pretty good program and with it, I no longer use
XyWrite as much. The way to import a XyWrite file into Excel is to use
Data-->Import External Data-->Import Data, and then choose the XyWrite file
- probably should label it as *.txt first as it will recognize it
better. Then choose Tab delimited and follow the prompts and it will put
the data into a database-like format. From there it can be easily exported
to Access, SQL, or FoxPro. Haven't used Oracle but I assume it would also
work there.
I use FoxPro a lot also, and in that database language the command to
import an XyWrite file would be to open a dummy database with the
appropriate fields and then use the command:
APPEND FROM C:\*\*\*.TXT DELIMITED WITH TAB
That would do a direct dump of XyWrite data, assuming it is, in fact,
delimited with tabs. If it isn't I just do a series of Global replaces in
XyWrite first before converting.
Bill M
At 12:01 AM 6/18/2005, you wrote:
XYWRITE Digest 2295
Topics covered in this issue include:
1) Re: conversion from xy to dbf
by Harry Binswanger
Message-Id: <4.3.2.7.2.20050617001922.00e47b80@xxxxxxxx>
Date: Fri, 17 Jun 2005 00:27:44 -0400
To: xywrite@xxxxxxxx
From: Harry Binswanger
Subject: Re: conversion from xy to dbf
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed;
x-Spamnix=checked;
Shorter than Patricia's way:
Import it into Excel.
Just launch Excel, and go to File/Open. Opening a non-recognized file type
causes a simple Wizard to open that will guide you through the two or
three steps. It will even accept a space as a delimiter. I know Excel
isn't a database program, but it probably can do what you want or allow
you to save the file in a way that will let a db program work fine with it.
I have a long xy file,
1) 1=item1 2=item2 3=item3
2) 1=item1 2=item2 3=item3
............................................
is there a good way to export all data to a dbf file ?
Thanks.
Harry Binswanger
hb@xxxxxxxx
Bill Mallon