Database Query

[NateG]

I have a small problem I suppose. I know how to do a database query in excel but I'm not sure how to get certain data in specific cells? Might not be possible but any help would be greatly appreciated.

 

[SydneyGeek]

Hi Nate,

I think the most you can hope for is to get the data ordered into specific columns -- by the order in which you select the fields when you build the query. Getting it into specific rows is not an option directly, because that will depend on the amount of data in the database.
However, there's nothing stopping you using a lookup function on the query data to grab just what you want.

 

[NateG]

Thanks, I had a feeling it would be really difficult if not possible at all. At least now I can look into doing it another way. Possibly with html and absolute postion.

 

[Russell Hauf]

When you say, "cells", what do you mean? Are you referring to Excel? If so, you can direct data to specific cells...

 

[NateG]

Yes, I'm talking about Excel. I want to to have data from Access show up in serveral different cells in Excel. Is it difficult?

 

[ddeldeb]

You can place data into what ever cell or range you want using VBA. I don't have an example to post at home (can do on Monday ) But it is something like [ value = worksheet.cell(A1) ] And using the "cell" referance you can even use variables in place of the A & 1 . Will check back on Monday to see where this is at.
Dave,,