One of the steps of the Import Data Wizard in Access allows you to modify the field settings during the import process rather than importing the data and making the changes to the fields later. I usually recommend this approach; however, I recently discovered an instance where skipping this step results in the loss of data!

In this tutorial:
  1. The problem
  2. The solution

1. The problem

If you import the data from the CSV file and then change the Data Type of the Hardcover field to Yes/No in Design View, the data in the Hardcover field will be deleted. It is well worth stepping through the import and recreating this problem.

the CSV file & import it into a new table.

See the post Access’ Import Text file function if you are unsure how to do this.

Open the Datasheet View and confirm that the Hardcover field contains many Y values.

Open the table in Design View and change the Hardcover field Data Type from Short Text (the default) to Yes/No. Switch to Datasheet View and confirm that the data in the Hardcover field has been deleted. There is no undo!

2. The solution

In essence, the solution is to select the Hardcover field during import and change its Data Type to Yes/No.

Changing a field's Data Type while using the Access Import Text Wizard.
Changing a field’s Data Type while using the Access Import Text Wizard.
  1. Scroll to the right until the Hardcover field is in view
  2. Select the Hardcover field
  3. Select Yes/No from the Data Type drop-down in the Field Options
  4. Click the Next> button

By MisterFoxOnline

Mister Fox AKA @MisterFoxOnline is an ICT, IT and CAT Teacher. He has a passion for technology and loves to find solutions to problems using the skills he has learned in the course of his IT career.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.