using access to filter data

[annipy]

bad title but...

I have a huge amount of data in Excel that I am sorting by instances.
Example: I have a unique ID field, and any ID that have multiple instances,
that is, more than one line item, I must copy into a separate worksheet. Is
there a way that an Access database can perform this function more
efficiently? There are over 7000 lines of data and it is taking an
inordinate amount of time to complete. Thanks for your help.

 

[John W. Vinson]

bad title but...

I have a huge amount of data in Excel that I am sorting by instances.
Example: I have a unique ID field, and any ID that have multiple instances,
that is, more than one line item, I must copy into a separate worksheet. Is
there a way that an Access database can perform this function more
efficiently? There are over 7000 lines of data and it is taking an
inordinate amount of time to complete. Thanks for your help.

Trivially easy in Access, with a Query:

SELECT [ID] FROM Table
WHERE Count(*) > 1
GROUP BY ID;

With a 7000 row table you'll get the result before you can blink.

 

[annipy]

Thanks John. I'll try it.
--
APM

bad title but...

I have a huge amount of data in Excel that I am sorting by instances.
Example: I have a unique ID field, and any ID that have multiple instances,
that is, more than one line item, I must copy into a separate worksheet. Is
there a way that an Access database can perform this function more
efficiently? There are over 7000 lines of data and it is taking an
inordinate amount of time to complete. Thanks for your help.

Trivially easy in Access, with a Query:

SELECT [ID] FROM Table
WHERE Count(*) > 1
GROUP BY ID;

With a 7000 row table you'll get the result before you can blink.