By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,102 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 14 Apr 2004 15:24:41 -0700, Br******@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.

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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.