Avatar of upobDaPlaya
upobDaPlaya
 asked on

MS Access DoCmd.TransferSpreadsheet - Export in 2003 or 2010

If a user has MS Excel 2010 I want to be able to transfer a MS Access query to MS Excel 2010.  If the user though has MS Excel 2003 I want the MS Access query to export to a MS Excel type of 2003.  What are your suggestion when exporting MS Access data to MS Excel when the users may have various versions of MS Excel ?
Microsoft Access

Avatar of undefined
Last Comment
upobDaPlaya

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
jerryb30

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
upobDaPlaya

ASKER
Great solution..thx
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck