How can I convert access table data types using macros?

[Limes]

Trying to work out if there is a macro function that will allow me to
automate the process of changing a text data type to hyperlink on opening a
table that has been created from a make table query.

 

[Steve Schapel]

Limes,

I have not done this, so I don't know the details, but you can run a DDL
query using the ALTER TABLE statement. I think you will probably need
to add a new hyperlink field using an ADD COLUMN, then run an Update
Query to copy the data from the text field to the hyperlink field, and
then another DDL query with DROP COLUMN to remove the text field.
Something like that, anyway.