I need to import one delimited text file into vfp, but the text file
contains 275 fields. I realize I need two dbf's because FP only
allows 254. I want to import 250 in the first dbf and 25 in the
second (with a matching key on both files of course). I have tried
importing the file to a memo field and manipulating the memo field but
have had no luck. Does anyone know how I could get all my fields
imported to two databases?

Ginny,
While the import would work on the first fields, to get the remaining fields, you'll need to do some coding. You could use Low-Level IO or FileToStr() to get the data into a parsable format - depending on the version of FP / VFP you are using.

Rick

"Ginny" <ginny.bonish (AT) tufts (DOT) edu> wrote

I know almost nothing of spread sheets, so forgive my foolishness, but if
there are not too many records, could you load it into a spread sheet, divy
it up, then export it to 2 dbf files?

Also, you might be able to import 253 fields, and make your 254th a memo
field, where the remaining records would end up. Then do a 'copy memo' to a
text file, then import that to your second table.

Just some thoughts.

--
Bill Browne
www.edgefinderstudios.com


"Ginny" <ginny.bonish (AT) tufts (DOT) edu> wrote

Ignore that....must have been half asleep when I wrote it....that's what
happens when I don't get my power nap.

--
Bill Browne
www.edgefinderstudios.com

"Bill Browne" <bill (AT) excalibur-dbf (DOT) com> wrote

That's OK, I understand. I actually have ended up figuring out how to
manipulate the memo field into which I appended the text file and was
able to get the fields into two databases. My only reservation is
that I know memo fields are easily corruptible when used over and over
again. At the very least this is an interim solution until I figure
out something else.

Thanks,

Ginny

I suggest that you (1) save your delimited text file in two separate files,
(2) remove all but a key field and alike fields in file #1 (3) remove all
but a key field and alike fields in file #2 (4) import the files into two
dbf's and use the key field to establish the relation between files.

Microsoft Excel is great for simplifying this task.

GEO.
www.theLOCAlfolks.com

"Ginny" <ginny.bonish (AT) tufts (DOT) edu> wrote

: "Bill Browne" <bill (AT) excalibur-dbf (DOT) com> wrote

: > >
: > > Also, you might be able to import 253 fields, and make your 254th a
memo
: > > field, where the remaining records would end up. Then do a 'copy
memo' to
: > a
: > > text file, then import that to your second table.
: > >
: >
: > Ignore that....must have been half asleep when I wrote it....that's what
: > happens when I don't get my power nap.
: >
: > --
: > Bill Browne
: > www.edgefinderstudios.com
: >
: >
: > >
: > >
: > > "Ginny" <ginny.bonish (AT) tufts (DOT) edu> wrote in message
: > > news:56dfbb20.0406210642.36a0f8b4 (AT) posting (DOT) google.com...
: > > > I need to import one delimited text file into vfp, but the text file
: > > > contains 275 fields. I realize I need two dbf's because FP only
: > > > allows 254. I want to import 250 in the first dbf and 25 in the
: > > > second (with a matching key on both files of course). I have tried
: > > > importing the file to a memo field and manipulating the memo field
but
: > > > have had no luck. Does anyone know how I could get all my fields
: > > > imported to two databases?
: > >
: > >
:
: That's OK, I understand. I actually have ended up figuring out how to
: manipulate the memo field into which I appended the text file and was
: able to get the fields into two databases. My only reservation is
: that I know memo fields are easily corruptible when used over and over
: again. At the very least this is an interim solution until I figure
: out something else.
:
: Thanks,
:
: Ginny
: