Excel Data to Access Query

[gsrajan]

Sorry if this is a very basic question. I have around 3000 numbers in an excel sheet. I need use those numbers in a query (Field Name: Package_Qty), the data type is text.

I need to add these numbers with " ". Please let me know what is the easiest way to do this. Someone told me to use ^ symbol and something else, I forgot.

Thanks.

 

[namliam]

well the & symbol is what you would use to add that space.

However why would you do so or need to do so?

in excel:
=A1 & " "

 

[gsrajan]

Thanks for the reply. My question is, how do I move those numbers to the access query criteria?

Thanks

 

[namliam]

you want to put 3000 numbers into a where clause? REALLY?
Dont think so, if you do need something along those lines, it would be easier, faster and more flexible to do a simple join with the excel sheet.

 

[gsrajan]

Thank you.