Hello,
I am trying to import a spreadsheet from Excel to a SQL (2000) table. All data seem to import fine except for the dates. I receive the following message:
Conversion invalid for datatypes (source column 'date_required' (DBTYPE_WSTR), destination column 'date_required' (DBTYPE_DBTIMESTAMP)
Hopefully someone will be able to help. I am a newbe to SQL and this is very frustrating!
Thank you.
I am trying to import a spreadsheet from Excel to a SQL (2000) table. All data seem to import fine except for the dates. I receive the following message:
Conversion invalid for datatypes (source column 'date_required' (DBTYPE_WSTR), destination column 'date_required' (DBTYPE_DBTIMESTAMP)
Hopefully someone will be able to help. I am a newbe to SQL and this is very frustrating!
Thank you.