Re: Record sequence problem on Import

Tech-Archive recommends: Fix windows errors by optimizing your registry

Jim

Perhaps one of the other newsgroup readers can offer a solution.

It would certainly be easier all the way 'round if you could get your hands
on the sort criteria used by the postal software...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Jim_P" <JimP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:031336D0-401F-4BAC-B629-2A43791C0B2D@xxxxxxxxxxxxxxxx
Jeff,

We are a non-profit direct mail house. We run our mailing files, such as
these CSV files, through postal sort software to get the best mail rates.
However, we want to build the addressing name and salutation following
very
specific rules. Before each mailing I was planning on running this process
to
import the file, build the addressing name, update each record, and output
put the file. I cannot let the import or export change the record order or
we
will not have the records in postal sequence for our mailing discount. I
don't know the sort criteria the postal software used or I'd re-sort the
file
once I imported it.

"Jeff Boyce" wrote:

Jim

Why? As in "why does it matter what order the records are in once they
end
up in Access?"

Access tables are "buckets o' data", with no readily apparent order.

When you want data from Access tables to appear in a particular order,
you
use a query and sorting criteria.

What am I missing?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Jim_P" <Jim_P@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CF8EDFF0-E635-48E5-924E-8E36C9F796AF@xxxxxxxxxxxxxxxx
I have created a form to allow a user to select any CSV file from a
certain
folder. The procedure then updates some information in the file and
re-outputs the file. I want to keep the process automated and not have
to
use
the Import Wizard. However, when using the DoCmd TransferText to import
the
CSV file the original record sequence is not kept during the import.
The
problem is the CSV file has gone through postal sorting software and
put
the
file in mailing sequence. I have to keep that sequence on the import
and
export of this file. Any way to accomplish this programatically without
using
the wizard to have Access assign the key sequence?





.

Quantcast