Alter Column data type

[nhandal]

I have a database in which I include a macro to retrieve data from a number of excel sheets into a table. I am trying to add a line of code that changes the data type of one of the columns after all data has been retrieved.

I hope someone can help me identify what is wrong with this line:

DoCmd.RunSQL "ALTER TABLE IntradaySheet ALTER COLUMN Time datetime;"

When I run this code it returns an error message that says: "Syntax error in ALTER TABLE statement"

Thank you in advance.

 

[pbaldy]

It's because of the field named with a reserved word (Time). I'd change that, but if you can't try:

DoCmd.RunSQL "ALTER TABLE IntradaySheet ALTER COLUMN [Time] datetime;"

 

[nhandal]

pbaldy,

Thank you very much, it works with the [Time] syntax as you suggested. That was really helpful.

 

[pbaldy]

Happy to help, and welcome to the site by the way.