If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pasting data from Excel
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 |
#2
|
|||
|
|||
Pasting data from Excel
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 |
#3
|
|||
|
|||
Pasting data from Excel
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 |
Thread Tools | |
Display Modes | |
|
|