Hey everyone, i'm having a weird problem when i import an excel
spreadsheet into a table. all data is imported fine except some of the feilds that are meant to be dates are converted to text... but some remain dates...???

Code:
Function funcImport(strTableName, strFileName As String)
On Error GoTo funcImport_Err

    ' Close Table
        DoCmd.Close acTable, strTableName
    ' Delete Table
        DoCmd.DeleteObject acTable, strTableName
    ' Import Spreadsheet into table
        DoCmd.TransferSpreadsheet acImport, 8, strTableName, strFileName, True, ""

funcImport_Exit:
    Exit Function

funcImport_Err:
    MsgBox Error$
    Resume funcImport_Exit

End Function

any help would be appreciated... thankyou

Is the field listed as a date field in the Excel spreadsheet?

Many time people take dumps from databases into Excel and Excel uses General on most of the fields, which are then forwarded to the new database which guesses formatting.

There is code to set the format of a particular field and there was a post on it in this forum. I would format the Excel spreadsheet before I imported it if it is not formatted as a date column already.



mmcdonal