wouldn't you provide more details?
or the code you are using to import data from Access?

On 26 Lut, 22:07, Bunky wrote:
I have a query in Access that has all the data I need but it is strung out
over many cells when I click on the tool that sends it to be analysed in
Excel option under tools it goes right accross the page. *The client wishes
to see it as they do today which is a spreadsheet of about 3 columns and 6
rows. Is there a way on the import I can tell excel to take this data and put
it in the 3rd row in the 2nd column and this data goes to 1st row in the 3rd
column etc.?

I have not used many of the Excel features yet so please keep it simple if
possible.

Thanks for your assistance.