Creating a checkbox field through a make-table query

[kviglas]

Hello to everyone,

I have a colleague who executes a make-table query that reads a txt file. While doind this, he wants to convert two columns (binary format) to checkboxes (Yes/No format). Is there a way to do that?

Thanx in advance

 

[namliam]

binary means it is allready in true/false format... (possibly need to add a - sign but thats about it...)

However you cannot (as far as I know) tell access to make it a checkbox.
Only way to do this is to have the table ready and waiting. Changing the create table into an insert query.