Exporting to a specific worksheet

  • Thread starter Thread starter Anthony Viscomi
  • Start date Start date
A

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
 
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
 
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.
 
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.
Click to expand...
 
Back
Top