Changing table field format using VBA

[LB79]

Hello,

Please can someone tell me if I can change a table field properties using VBA?
I have a table which imports a field as Date, but I want to change it to Text.

Thanks for any advice.

 

[ghudson]

As long as you are importing the data into an established table [setup the way you want it] you should not need to change the field type with VBA. I advise against importing data into a new table each time you import a file via VBA.

Check out this site for code on how to alter your table... http://allenbrowne.com/func-DAO.html