Import to Yes/No data type

[mjoerge]

Hi, I'm trying to import data from an Excel worksheet into an Access table. The table contains a column with datatype 'Yes/No'
which fails during import. I'm wondering what values to put in the worksheet for the Yes/No colum to accept the import.

 

[CJBIRKIN]

Hello

I would try 1 and 0. If i remeber correctly it's 1 for true and 0 for false or yes and no.

Chris

 

[Ally]

Yes / No fields are actually -1 for yes and 0 for no.

BUT, if you keep your fields as they are, yes and no, and import, then go into the design of your database once imported and change the field datatype to Yes / No from text, it will automatically convert them.