Transforming data types

[dirk rogers]

I imported an excel spreadsheet into Access. A few of my Fields are 'Text'
data type and I want to make them 'Yes/No' data type. The problem is I lose
my data when I try to transform the columns. Any ideas on how to keep my
data and transform?

 

[jacksonmacd]

Create a new Yes/No field and use an Update Query to populate it based
on the contents of the original field. Delete the original field.

I imported an excel spreadsheet into Access. A few of my Fields are 'Text'
data type and I want to make them 'Yes/No' data type. The problem is I lose
my data when I try to transform the columns. Any ideas on how to keep my
data and transform?

**********************[email protected]
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security