I am using ACT 6 and am trying to "split" the database between records
for customers and junk records. The accounts designated as "customers"
have that word in the ID field, and I am using that field as a lookup
to separate these records from the rest of the database, which have
nothing in the ID field.
When I try to use the Export Wizard, it does not allow me the option
to choose the lookup records to export. It seems to work, but when I
get to the end of the Wizard, the only choices it allows me are to
export parts of records or export the whole database (export lookup is
greyed-out). I tried the alternative, which is to do a lookup on
records that have blank ID fields....but ACT will not allow me to
choose a blank field (it will only accept something in that field).
This is a 5000+ name database, so it would take me forever to manually
delete the unwanted records from a copy. I can export the customer
records to a text file...but then how do I get them back into ACT and
insure that no data is truncated? Some of the files I am dealing with
are years old, so to lose the information would be disasterous.
Can anyone give me an alternative as to how to make this happen? Is
there a manual way to export from ACT? The "customer" database is only
about 400 names, so the majority of what I don't need is much larger.
Bridget