[Date Prev][Date Next][Subject Prev][Subject Next][ Date Index][ Subject Index]

Re: Converting Xy to dbf



What are you doing with the dbf file? Are you giving it to somebody else
with a database program that reads dbf files? If so, you might be able to
simply give that person the text file and let him import it into his own
database program himself.

If you have no separators, you have a couple of choices. You can import it
as a fixed-length file. Or you can copy the file, and use XyWrite to change
the "Content1" to a convenient separator, like tabs or comma-delimited. In
comma-delimited form, you can import it into a Lotus-compatible spreadsheet
and it will line up into columns very nicely.

How far did you get? Did you download PC-File? If you did, the best thing
would probably be to try to create a *small* test database, and play around
with it for a while, importing a few simple files, until you figure out how
to handle the big files you're using.

Norman


At 02:38 PM 11/24/03 -0800, AndyCh wrote:
>
>Xy file:
>
>
>24) Title 1=content1 2=content2 3=... 4= ... 5=... Note=
>
>There is no special separations between fields.
>
>I need a DBF file
>the structure should be
>
>NUMBER
>TITLE
>CONTENT1
>CONTENT2
>CONTENT3
>...
>CONTENT5
>NOTE
>
>I must import data from xy files , about ten very long files,
>to a .dbf file,
>
>but I was unable to do it in a simple manner,
>the matter seems (to me...) quite hard...
>
>By.
>
>
-------------------------------------------------------
Norman Bauman
411 W. 54 St. Apt. 2D
New York, NY 10019
(212) 977-3223
http://www.nasw.org/users/nbauman
Alternate address: nbauman@xxxxxxxx
-------------------------------------------------------