By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Export data from access adp

P: 1
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
Share this Question
Share on Google+
1 Reply

P: 68
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.