I hava a delimited text file(comma seperated) which I imported to access using code. The problem is that when the file is imported and the table created, all the fields created as TEXT type. I want to know if it is possible to write a code (using DAO)to change the type of a field and if so how Can I do so.
my table is Customers in this table I have Orders field. I want to write a code to change the type of the Orders field from TEXT to Double and set its format to FIX.