Microsoft KB Archive/141005

= ACC: Import Specification Doesn't Convert Properly =

Article ID: 141005

Article Last Modified on 6/25/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q141005



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
If you create an import/export specification in Microsoft Access version 2.0 for a fixed-width table with no fields specified in the specification grid and then convert the database to a Microsoft Access for Windows 95 version 7.0 database, you may receive one or both of the following error messages when you attempt to access that specification in Microsoft Access 7.0:

An error occurred trying to load import/export specification 'Spec name'

  -or-

Page fault in vb232.dll



RESOLUTION
To work around this behavior, follow these steps:


 * 1) Open the database where you want to store the import/export specification.
 * 2) On the File menu, click Imp/Exp Setup.
 * 3) Select the proper specification from the Specification Name box.
 * 4) Fill out the columns in the field information section for each field in the text file, and then click OK.
 * 5) Quit Microsoft Access 2.0 and start Microsoft Access 7.0.
 * 6) On the File menu, click Open Database.
 * 7) Select the database you want to open. Note that when prompted, you are now able to successfully convert the Microsoft Access 2.0 database to Microsoft Access 7.0.



Steps to Reproduce Behavior
 Open a blank database in Microsoft Access 2.0. Open the sample database NWIND.MDB. Create and save the import specification for Text (Fixed width). Convert the database to version 7.0. On the File menu, click Get External Data, and then click Import.</li> In the Import dialog box, under Files Of Type, select "Text Files (*.txt, *.csv, *.tab, *.asc)."</li> Find and highlight any text file, and then click Import.</li> In the Text Import Wizard dialog box, click the Advanced button.</li> In the <File Name> Import Specifications dialog box, click Specs.</li> Highlight the Spec name created above and then click Open. Note that you receive the following error message:

An error occurred trying to load import/export specification 'spec name'

</li> Click OK.</li> Repeat steps 8 - 11. Note that you receive an error message, the details of which state that a page fault has occurred in vb232.dll and that Microsoft Access will shut down.</li></ol>

<div class="references_section">