Microsoft KB Archive/200672

= ACC97: INI File Created When Exporting to Lotus Format =

Article ID: 200672

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q200672



SYMPTOMS
When you export from Microsoft Access to a Lotus 1-2-3 format of *.WK1 or *.WK3, an associated INI file with the same file name is also created. For example, if you export Table1 to the WK1 Lotus 1-2-3 format, an INI file with the name Table1.INI is also created in the same folder.



CAUSE
The INI file is used internally by the Microsoft Jet database engine to determine the number of columns and the data type of each column during the export process.



MORE INFORMATION
If the INI file exists when linking a Lotus 1-2-3 file, there will be a slight performance gain because Microsoft Access will not need to determine the column and data type information when linking; otherwise, the INI files can be safely deleted with no negative effects.

Steps to Reproduce Behavior

 * 1) Open the sample database Northwind.mdb.
 * 2) In the Database window, select the Categories table.
 * 3) On the File menu, click Save As/Export.
 * 4) In the Save As dialog box, click To an External File or Database. Click OK.
 * 5) In the Save as type list, click Lotus 1-2-3 WK1. In the File name box, type WKTest . Note the folder name in the Save in box, and then click Export.
 * 6) Open Windows explorer and browse to the folder in which you saved the file. You will see the WKTest.WK1 and also a file named WKTest.INI.

Additional query words: prb 1 2 3 123

Keywords: kbprb KB200672

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.