From Text to Date/Time

Using a macro, I am importing a text file into an access table. I have a
query which reformats the date fields into the proper format, but now I need
a way to change the field type from text to date/time. Can this be done
using a macro?

All help much appreciated!

No, it can't. Changing field types isn't that straightforward at the best of
times, and a macro certainly isn't capable of it.

The usual way is to add a new field, of the correct type, to your table, run
an Update query to transfer the data from the old field to the new field,
delete the old field and rename the new field. This is actually what Access
does under the covers when you make such changes through the GUI.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Deb" wrote in message
...
Using a macro, I am importing a text file into an access table. I have a
query which reformats the date fields into the proper format, but now I
need
a way to change the field type from text to date/time. Can this be done
using a macro?

All help much appreciated!

Doug,
So are you saying there is no possible way to automate those sequence of
events as a macro? What about in VBA?

"Douglas J. Steele" wrote:

No, it can't. Changing field types isn't that straightforward at the best of
times, and a macro certainly isn't capable of it.

The usual way is to add a new field, of the correct type, to your table, run
an Update query to transfer the data from the old field to the new field,
delete the old field and rename the new field. This is actually what Access
does under the covers when you make such changes through the GUI.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Deb" wrote in message
...
Using a macro, I am importing a text file into an access table. I have a
query which reformats the date fields into the proper format, but now I
need
a way to change the field type from text to date/time. Can this be done
using a macro?

All help much appreciated!