Export table, but no Wizard

[joewashb]

Export table, but no Wizard!! Help me out

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-
Thanks for your suggestion. I double checked that all of the wizards are in fact installed. The installs are complete for each of the computers mentioned. Also, I am unsure how not having a wizard installed would allow it to run once, but not subsequently. Any other suggestions would be very helpful here. Thanks
joe

 

[Mile-O]

Have you tried searching on Microsoft's Knowledge Base

Click Here

 

[joewashb]

My solution

Well, after spending way too much time working on this, here is a workaround to the situtation I outlined above.
The following VB code can be used to update a specification file that already exists, and could be used to create one that never existed. I still havent isolated the reasoning behind the mysterious export wizard, but, ultimately, I acheived a good outcome.

Public Sub DoSQL()

Dim SQL As String

SQL = "UPDATE MSysIMEXColumns SET MSysIMEXColumns.[Start]='63' WHERE MSysIMEXColumns.[FieldName]='event number'"

DoCmd.RunSQL SQL

End Sub

I was trying to change the fixed width export starting position of a column called event number. This statement changed the value from 64 to 63. (Yes, all this for a one position move). Thanks
joe