Pasting data from Excel

[David]

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

 

[JLatham]

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

 

[Shane Devenshire]

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.