On 14 Apr 2004 15:24:41 -0700,
BridgetS@ix.netcom.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]
