Transforming data types

D

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?
 
J

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?
Click to expand...
**********************[email protected]
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Top