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!
