Problem with segmenting an ACT database (records will not export)

[Bridget Willey]

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

[Tom van Stiphout]

Re: Problem with segmenting an ACT database (records will not export)

On 14 Apr 2004 15:24:41 -0700, BridgetS@ix.net com.com (Bridget Willey)
wrote:

This is not really an Access question (the purpose of this forum), but
this is your lucky day :-)

One of the files in the Act database is a DBF file. Assuming the
filename is not more than 8 chars (otherwise: temporarily rename it),
you can link to it from Access.
Then you can write an Update query to set all blank IDs to "NO
EXPORT". The way I read your message, you've got the rest covered.

-Tom.



[color=blue]
>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[/color]