Hi,

I'm trying to change the datatype of the column 'test' from Number to Date/Time in the table 'tbltest' using a SQL statement. This is my code:

    STRSQL = "ALTER TABLE tbltest MODIFY (test DATETIME)"
    DoCmd.RunSQL STRSQL

However when I run the docmd I get a run time error:

"Syntax error in ALTER TABLE statement"

Any idea would be appreciated.

Pedro

Hi Pedro,

strSQL = "ALTER TABLE tbltest ALTER COLUMN test DateTime;"

HTH,

Bob