Question URGENT HELP - Access Query to Excel in excel Range

[jay9324]

Dear All,

Please help me to get this done as i am stuck for week. Question is:
1. Run the Query and export the recordset to Excel with below requirement.

Say for Example Query returned 20 rows of 7 column.

1. I want to paste 10 records in Excel Range A1: E10.

2. rest 10 records in A14:E23.

Please help guys.

Regards,
JK

 

[Twincam]

Have a look at this thread...

http://www.access-programmers.co.uk/forums/showthread.php?t=251416&highlight=create+workbook

It shows how to create and populate an excel spreadsheet from access.

 

[jay9324]

Dear All,

Please help as previous answer does not answer my question.
I want to print half of the recordset rows in 1st range and other half of
recordset data to other range.

Please Help..!!!!

 

[Frothingslosh]

For starters you should try telling us what you have done and what the result was, including exact error messages. The way you phrased your original post, it sounds like a homework assignment.

 

[spikepl]

You should know that this is a volunteer forum, so shouting "URGEEENT" cuts no ice with anybody here. You are the one who got yourself into the predicament, after all.

But if this really is urgent then sprinkle some real $ over it, to show that you mean it. Otherwise wait in line

 

[CJ_London]

I want to print half of the recordset rows in 1st range and other half of
recordset data to other range.

this will get you started - check all the links

http://stackoverflow.com/questions/...vba-to-an-excel-spreadsheet-in-same-directory

 

[jay9324]

Dear Friends,

Please help for my mentioned question.