I've got a table in MS Access 2000 which contains text strings of "Y" or "N" (for yes and no, obviously).
I'm trying to move that data using ADO or a append query, into a MS SQL Server 7 table, where the data type is formatted as BIT.
Anyone know of the conversion or formatting code to do this?
I know how to move it, I just need to convert the data before or as I move it.
I tried CBool and CByte but got data type conversion errors each time..