access 2010 vba question

[jscriptor09]

Hi folks

I am importing a excel 2007 spreadsheet into my DB.
The spreadsheet has 4 columns that are Date type.


After the import is completed, I checked the data type in Access 2010 for this particular table and these 4 fiels have Text datatype.

As a result, when I tried to use the table along with another table for a query (linking dates), I get type mismatch from the query.

I tried to do Docmd.runSQL "alter table ....." to change the field type using SQL DDL, but that ended up deleting all the imported date.

I am really stumped here as I can't figure out how to set the field type to Date/Time with Short Date Format at run run time using VBA.

Many thanks for any help/example on how to do this.

Mike

[jscriptor09]

Got it ...
DOCMD.RunSQL "ALTER TABLETableName ALTER COLUMN [Col Name] DATETIME"

I was missing the ALTER COLUMN