There's gotta be an easier way

[0qiou]

I have to take an excel spreadsheet with about 1300 rows of info and I need
130 of them. Is there an easy way to take the 130 ID#s from another sheet
and use it to either say I want records that match these numbers or a query
to give me all number except the 130 (maybe make a simple table from them)
then delete all the exceptions that come up from the query? It's been about
5years since I looked at access, so would think this would a pretty simple
thing in in but I don't remember enough to know what to do or where to
begin........

 

[Jeff Boyce]

Here's another approach...

Import the complete list into Access.

Modify the table definition by adding a KeepMe Yes/No field.

Go through and "check" the 130 you wish to keep.

Create a query that deletes all rows not marked "KeepMe".

You could re-modify the table definition and remove the "KeepMe" after
you're done.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I like Jeff's suggestion. Though I would probably do the "checking" in Excel.
Just add a column, put an x in the cell for those rows you want to keep, then
import the data to Access.

Create a query, put the "*" in the first column, put the "x" field in the
second column, and type "x" in the first row of criteria.

That should do it.

 

[0qiou]

Yeah that's what I thought when I read it......or just another column with
anything in it and use not = to that.......X and then <> X. or whatever.

THANKS, this will reduce the time or selectively deleting junk :O)