ACC97: Microsoft Access Behavior When Importing Text Depends on Version

MORE INFORMATION

Steps to Reproduce Behavior

1. Open Microsoft Access 2.0 and the sample database Nwind.mdb.
2. Make a copy of the Customers table(Structure Only) and save the copy as CopyOfCustomers.
3. Open the CopyOfCustomers table in Design view and add the default value Charlotte to the City field. Close and save the table.
4. Open the Customers table in Datasheet view and delete the City field value from several cells. Close and save the table.
5. Follow these steps to export the table:
   
   
   1. On the File menu, click Export.
   2. In the Data Destination box, click Text(Delimited), and then click OK.
   3. In the Object In NWIND box, select Customers, and then click OK.
   4. In the Export To File box, click OK.
   5. In the "Export Text Options - CUSTOMER.TXT" box, click the "Store Field Names in First Row" check box, and then click OK.
6. Follow these steps to import the table:
   
   
   1. On the File menu, click Import.
   2. In the Import box, click Text(Delimited), and then click OK.
   3. In the Select File box, select the Customer.txt file in the File Name box, and then click Import.
   4. In the "Import Text Options - CUSTOMER.TXT" box, click the "First Row Contains Field Names" check box, click "Append to Existing Table," and then select CopyOfCustomers in the list box.
   5. Click OK twice to the Import messages. Close the Select File box.
7. Open the CopyOfCustomers table.
   
   Note that for cells in the City field that were blank, the default value of Charlotte has been added.
8. Open Microsoft Access 7.0 or 97, and repeat steps 2 through 7 for the particular version of Microsoft Access.
   
   Note that for cells in the City field that were blank, the default value for the field has not been added.