export specific fields to Excel

R

rebeccax

I have a crosstab query that I want to export to Excel. I'm familiar with a
number of methods for doing so, but this time I want to send only the first 9
fields. The number of records will vary. I've been reading the messages of
others like Ken Snell. (Ken - your posts are enormously helpful)! So my
little yodas, how do I make this happen? Is it better to push it out from
Access or grab it from Excel? FWIW, I hate coding in Excel. I'm using
Access 2002, Windows XP.
 
P

PieterLinden via AccessMonster.com

rebeccax said:
I have a crosstab query that I want to export to Excel. I'm familiar with a
number of methods for doing so, but this time I want to send only the first 9
fields. The number of records will vary. I've been reading the messages of
others like Ken Snell. (Ken - your posts are enormously helpful)! So my
little yodas, how do I make this happen? Is it better to push it out from
Access or grab it from Excel? FWIW, I hate coding in Excel. I'm using
Access 2002, Windows XP.
Click to expand...

Can you base a query on the crosstab and output that to Excel?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Report with Graph to Excel error 2495 1
export specific fields from report to excel 4
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
export to excel 1
Export Access pivot table to Excel 0
Export to Excel - calculated field type conversion issue 0
Export to XML - error 31532 0
Export serial date to excel as a string 4

Top