I am importing a .CSV into an access 2007 database. All the fields in the .CSV are text and some need to be number, date, text etc when being imported into access. How can I change multiple fields from text to a useful data type without going into table design after each import? Macro? Thanks in advance.
