Re: Best way to import text file into existing table on a daily ba

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

The sorting that you see in the table (when viewing in Data*** mode) is
unimportant. It has no effect whatsoever on your data. The only sorting that
has an effect (and just on display, not on the data) is the ORDER BY clause
in a query, or the Sorting & Grouping settings in a report.

(Of course, if you're saying that the order of the records in the text file
is important for identifying pertinent new data, then we may need to
completely change the approach to what you want to do. Once you import data,
you have no "sort" or "order" any more that may have existed in the text
file, unless there is some field/value in the text file's records that you
can use to impose sorting on the data after they're in the temporary table
and that would mimic the order that was in the text file.)

How can you differentiate between a new patient and an existing patient when
you view the data from the text file?
--

Ken Snell
<MS ACCESS MVP>





"bluesky" <bluesky@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:63BBF268-5F3A-4CAC-876C-780D94FE54CF@xxxxxxxxxxxxxxxx
Hi Ken,

I'm still working on this, though almost done!!

When I transfer the text file into my temporary table, it seems to sort on
the first field, which is medical record number. I would not like it to
do
this, any suggestions?

When I get the text file reports, new patients are just appended on, and I
would only like to transfer the new patients into my temporary file, is
there
a way to do this, do I need to write VBA code? Also, of the new patients,
I
only want to transfer those with Yes for a certain field, do I do this in
VBA
also?

Thanks a million!

Bluesky

"Ken Snell (MVP)" wrote:


"bluesky" <bluesky@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FCB903CD-6286-4506-A2C4-E02206DAE241@xxxxxxxxxxxxxxxx
Hi Ken,

OK, I reread you email, and you did give instructions how to create an
Import Specification. I'm such a goof. sorry, now when I went back to
the
macro, it was there!!! Ok, back to working on this.



< chuckle >

--

Ken Snell
<MS ACCESS MVP>






.

Quantcast