I am trying to import an XML file into MS Access 2003, through File>Get External Data>Import. And I want to import a field as boolean. I have pre-built the tables and importing the data only. I am confused that what should be value of boolean in XML so that it can easily get imported as aceess boolean variable.
Hmmm I'd go with 0 for false and -1 for true. But I suspect it would also convert these pairs as well...
False Value True Value 0 -1 0 {any non-zero integer} False True No Yes