MS Access output to Excel


I currently use the following statement to output tables in Access to Excel:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "AccessTablexx", outputFileName, True

I now have a new Access table but I only wish to output rows from the new table where a field value is > 0.  So if there are 100 rows in the table and only 6 rows have a value > 0 for a field I wish to output only those 6 rows to Excel.

As an alternative I could use VBA to remove rows in the Excel worksheet where the field value is 0 but I would prefer to filter the output from Access if that was possible.

Many thanks
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


Instead of a table you could create a query with your specifications and export it

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "yourAccessQuery", outputFileName, True


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
alisonthomAuthor Commented:
Yes, that would also be fine.  Thank you!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.