Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-03 : 08:12:13
|
| Narender writes "I have a table with 1st three column as text, last two as numeric. I wanna import them in SQL server Database. But when I import this I always get all 5 column as VARCHAR while last two sholud be as numeric. How can I do this." |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2004-06-03 : 08:44:39
|
| Use the import wizard and when you get to the part that says Select Source Tables and Views, you are prompted to pick a Destination table. After selecting the destination table, click on the gray box with three dots under the Transform column. When the Column Mappings and Transformations box pops up, change the type of the two numeric columns to one of the numeric types (int, float, etc)Jeremy W. Oldham |
 |
|
|
|
|
|
Importing Text File into SQL Databse