Macro to change data type

A

apex77

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change data type 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Copy previous record into form field 0
Finding the proper style field and the numbered paragraph value within the style 0
Transfer Text and Overwrite 1
Finding the right style field in VBA 0
Cannot import CSV file into ACCESS 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top