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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2004-10-25 : 12:58:01
|
| I am using dts to import an excel file to a table.I have a field phonenumber and cellnumber and dts is automatically converting it to a float and displaying it like 3.01416e+029What can I do to keep in in the number format. (I even prefer if the field is a varchar datatype)? |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-25 : 13:21:36
|
| See the column to TEXT in ExcelorPre-create a table with appropriate columns / data typesKristen |
 |
|
|
|
|
|
importing from excel