"oh, it's just a little bunny, isn't it"

Tom, If you are having trouble understanding the SQL syntax in the scripts above, you definitely need some more training in this area.  Get to it!  You will benefit by...

Only 255 users?  This is a pretty serious application.  You can't expect this to work with a PC mentality or a PC budget.   Did you know that this kind of...

Use Enterprise Manager to create new databases and tables. Try right clicking on everything to bring up the common tasks.  Create a Server Group first, then a new SQL Server Registration,...

In which process?  export from Access?  or just manipulation of the text file?

when exporting a table from Access to a text file, the export wizard (Advanced button) provides the option to...

Do a search on the forum's knowledge base.  I've downloaded some really awesome scripts in the past related to gathering users and roles.  The content of this forum is incredible.

Thanks to everyone for the excellent feedback.   In response to questions posed by RD Francis.

Segregation by time period.  The database is a “rolling” twelve...

Yes, but what defines the "second instance" ? Is it arbitrary ? Or based on a sort order of some other column or columns ?

>>there are other fields which identify...

I hope this clarifies.  

Table A.PK  (source table w/duplicates allowed on field PK)

-------------

1

2

3

4

Thanks for all the help.  I enjoyed ALL the dialogue.  To respond...

#1 I did an exhaustive search on this site (1.5 hrs) to find the answer before posting.  Hang me...

Having been involved with database developments for over 20 years, I don't know where to start with your proposal.  On the other, with all the grey hair, I should have...

I had to read your description a few times before understanding it.   I get it now.  Here's what you need:

select *

from table

where products_ID not in (select product_local from table);

you would...

The Microsoft Query functions within Excel will allow you to pull the data from an SQL data source.   You can save the query, refresh it when you enter the spreadsheet, and...

Awesome technique and perfectly legitimate.  Used to do this with Unix text files into Oracle about 10 yrs ago, when there was nothing like DTS.  Don't think of this as "quick and...

When importing into Excel (from any file) it is always more accurate and trouble free to use tab delimited files instead of csv.   Inevitably, there are commas in fields that...