SQL Server Express Conversion Problem

[Elysium]

I apologize if this is the wrong forum for my question. In any case, I just downloaded SQL Server 2005 Express and I have an issue with a CSV import. I established a "Linked Server" to a directory where my csv files are. I then issue Insert statements using the csv files in the "from" syntax. Everything is fine until SQL comes to a column with something like this:

Row 1: 123
Row 2: 456test

SQL Server wants to treat 123 as an integer and it disregards 456test all together. If the destination column's data type is "Text", I get this error:

Msg 206, Level 16, State 2, Line 23
Operand type clash: int is incompatible with text

Why is this happening?

Randy