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

Actually this did get posted in the Excel forum.

The answer to your question appears to be NO. I determined this simply by
creating a dummy database in Access with a table and then attempting to
create a query to extract data from the table and chose 3 cells with valid
criteria in them and pasted them into the criteria section of the query.
Boom! Error. All 3 values went into a single criteria row, so Access choked
on it.

"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

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