title: Access 97 copying field type to other table
body: <p>In Access 97, I have a table which has fields a and b. Is is possible to find via VB what type are those fields, like varchar or integer? I'm trying to copy the name of the field and its type to another table and replace it if necessary in another table. I can do it using mouse but I don't know how to do it via VB. The result field should contain no data.</p>