469,623 Members | 1,238 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

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 2583
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 gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.