Exporting to a specific worksheet

[Anthony Viscomi]

I've posted this question once before, but I hadn't receive any real
solutions. I need to export data (crosstab queries) to Excel. That's the
easy part! I need each crosstab query to be a seperate worksheet within the
same workbook. That's my dillemma!

Any thoughts?

Thanks!
Anthony Viscomi

 

[Guest]

Anthony
You might look into using MSQuery to bring your query data into a specific
range of an Excel worksheet.

Check with one of the Excel groups for more details and do a search for ms
query
in Excel help.
Rosco

 

[Guest]

hi,
do it from the xl side with microsoft query. you could
assign the import from access to a button on the sheet.
users could refresh the table when they want.
I have seveal files that do this. works for me.

 

[Anthony Viscomi]

thanks all!

hi,
do it from the xl side with microsoft query. you could
assign the import from access to a button on the sheet.
users could refresh the table when they want.
I have seveal files that do this. works for me.