I have a text file that I am importing into an Access table that was
generatred from data exported from a Word file. Several (about 20-30)
fields are from check boxes on the Word form. These fields have either
0 (Not checked) or 1 (Checked). Due to requirements from a third party
software application, they HAVE to be either Y(Checked) or N (Not
checked) and MUST be a text field in the Access table.
I will be importing several thousand of these files into the Access
table so I will want to automate the process as much as possible.
I am using MS Office 2003 Suite.
I know I can import fields into a Y/N field type, display them as Yes/
No text box fields and then change them to text fields with a field
size of 1 but this is a very labor intensive task when there are 20-30
fields per file imported.
Any ideas as to how to approach this?
Thank you in advance
Debbie