Export table, but no Wizard

[joewashb]

Here is my current dilema:
I have an Access database that uses a macro to export a table in a fixed width format to a text file. The spec file (not initially created by me) has an order id field passing 2 characters and I need it to be 3. All of the posts I have seen thus far have spelled out the solution to be as easy as setting up a new spec file (or 'save as' the old one) by eporting a table and when the export wizard come up, chose the advanced tab...etc. When I chose export, however, I do not get the wizard. I get the option to export the table to.... I am not sure how this wizard was turned off, but I need to figure out how to get it back. To make matters even more interesting. I used a different computer hooked up to my LAN to access the database. That computer DID have the wizard, but only once. I have tried in vain to replicate this using other computers I have in the LAN (a total of 4 others), but none have the wizard (and thus, no advanced button). Did Microsoft build in any other way of getting to the specs other than through that advanced tab in the export wizard. Any thoughts on what I may need to do to get this turned on. If it would be helpful, I could find a way to get a link to the db, as there isnt anything confidential in it. Thanks for the help

 

[joewashb]

Pat-
The question is relavent to multiple forum topics. Any further input to the question at hand would be greatly appreciated. Thanks
joe

 

[Mile-O]

The question is relavent to multiple forum topics.

If you feel that it's relevant to multiple forums then choose the best suited forum for your question.

The people who answer, help, read, browse, etc. this site take the time to go through all the forums as no specific area is an area where their expertise falters.

Crossposting is an unwritten rule on this site. The fact that you have two - or more - threads open can waste the time of those willing to help.

If you have multiple active threads then the answer may have been answered quickly on one but will seem open on the others meaning that someone may spend the time answering you and then find that the thread has been already answered and the generosity they've shown in taking the time out to help has been a waste of their time.

 

[joewashb]

Mile-O-Phile-
Thanks for letting me know of the unwritten rule regarding crossposting. I do value the time and expertise of the individuals reading these posts.
In fact, I will make sure that each of the multiple posts on this topic have final comments thanking the individuals assisting me in the solutions (as well a a copy of that solution).
However, this banter on crossposting/multiple posts is not really productive. Thus, in the interests of those who choose to read these posts as well as my own, I will ask if anyone has seen this Export wizard issue before, and if they know of any solution or workaround. Thanks
joe

 

[Mile-O]

I still feel bound to redirect viewers to the initial thread.