Hi,

When you paste multiple lines into the criteria row of and Access query, all
the entries go into one cell, you could then put an OR between each one, but
you would need to do it manually.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"David" wrote:

Hello everyone,
I'm not sure if I should be posting this question here or in the Excel
forum but here goes. Is it possible to copy data from multiple cells in
Excel and then paste them into multiple lines of the criteria section of an
Access query? For example, Given cells and values: A1- 1
A2- 2
A3- 3
I would like to be able to copy this data from Excel and paste it into an
Access query like : Criteria: 1
or: 2
3

I am using Access 2002 SP3 and Excel 2002 SP3
--
Thanks,
David