sql server dts: We have Microsoft Access database (x.mdb) with "updated"
column like 03/16/2004 having datatype "text"

When I tried to import this database from SQL server, it
poped up an error message...if data source Microsoft
Access was selected, then it would not continue. If data
source Microsoft Access Treiber(*.mdb) was selected, the
import was successful, then everything is working except
this "updated" column which shows NULL instead of
something like 03/16/2004.

Any ideas?

Thank you in advance.

Try making the updatedate column as datetime instead of text. Then you
should select "Microsoft Access" as source not the Treiber stuff.

Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Developersdex http://www.developersdex.com ***

What is the datatype of the column in SQL Server after the import?

Rand
This posting is provided "as is" with no warranties and confers no rights.