472,096 Members | 1,325 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,096 software developers and data experts.

Export data from access adp

I have an access adp (MS Access 2003) connecting to a SQL 200 server. From the adp a user generates reports and using the built-in access export wizard can export said reports (which are either tables or queries run against a table) as the save as options available in the wizard.

What I really want to achieve is remove certain save as options from the default access export wizard.

After some research I have realized that customizing the wizard isn't possible, however I could create my own export wizard by calling the Windows fie open/save dialog box and setting parameter and all that. I have succeeded in saving the report as an access table, I am at a loss as to how to save the reports as Excel or Text files.

Many thanks for your anticipated help, Help!
Sep 12 '07 #1
1 2724
I've just posted a related response re' exporting to excel, that might solve your issue
Sep 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by Mike MacSween | last post: by
4 posts views Thread by Paolo | last post: by
16 posts views Thread by David Lauberts | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.