Import to Yes/No data type (1 Viewer)

M

mjoerge

Guest
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

Drink!
Local time
Today, 23:47
Joined
May 10, 2002
Messages
256
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

Registered User.
Local time
Today, 23:47
Joined
Sep 18, 2001
Messages
617
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.
 

Users who are viewing this thread

Top Bottom