|
|
Posted by Erland Sommarskog on 05/21/05 15:59
akej via SQLMonster.com (forum@SQLMonster.com) writes:
> Last question on the subject however i think it's impossible, in case the
> datatype are different in some columns (in the table and in the file)
> is it possible to convert in some way??? (using the BULK INSERT)
Not really sure what you mean here. Assuming that the file you import is
a text file, the data type will be different as soon as the target column
is not a character data type.
I have not dug deeply into this, but I would assume that the same
conversions to be available, that are available in SQL statements.
Maybe if you have a specific example, I can give some suggestions.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|