forcing a type cast

[mike55]

Hi

 

Is is possible to force a type cast when selecting from an access database

Consider: tableA with Columns 1.Id (int - size 3), 2.Name (text - size 50) and 3. date (date)

 

Now i want to do a select * on the table but i want to select the date as a text variable??

Select Id, Name, (date) as text

from tableA

 

As i need to take the result of the select statement and insert it into a SQL Server 2000 database where the date is represented by the datetime variable. When i try to do it without any modifications, i get an error message telling me that the date in access is bigger that the date in SQL SErver

 

Any suggestions.

Mike55

Edited October 8, 2004 by mike55

[Robby]

You can use CAST() in your Select during the Import process.

 

Are you doing this using .NET code or with a DTS package?