Record sequence problem on Import

[Jim_P]

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?

 

[Jeff Boyce]

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]

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]

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