Copying from excel to access

[doddsy]

Using office 2003. I have a column of data in excel that i want to paste to a column in a select query in access. The end result that i want is that each cell value from excel will fill a single cell in the access query - in essence forming the same column that I have in excel.

When i copy and paste all of the excel data goes into one access "cell".

Is there a way to paste the data in the way that I want?

[NeoStarO1]

I would think it would be far easier to import the data rather than copy and paste it.

[doddsy]

Hi Neo - That's possible - thing is this is a database at work - I don't know much about databases but I do know that I don't want to interfere with the data that's there. I'm setting up a query to return some values based on what's input and the parameters selected for the query. I'm just not sure if it's safe to import to the query ... I'll ask at work. For now I did a lot of copying and pasting and got the result that i needed. I just can't help thinking there's an easier way.

[NeoStarO1]

Well i'm not a database expert but if you're running a query that query needs values to draw from. You'd have to have a table to draw from so to run the query you'd could create a new table (need to set the primary keys and such in your table & also create the relationships to the other tables) then can import the data as a new table and run your query with the fields you need to draw your query from.

Did that make sense? Not very good at explaining database stuff.