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 |
|
miranduh8
Starting Member
4 Posts |
 Posted - 2006-06-01 : 11:02:29
|
| I am trying to import an excel spreadsheet into a new table. The data in the excel spreadsheet is in decimals. For example: 0.000675. When importing, the zeroes after the decimal point are removed and the above example is imported as 6.75. The data type is automatically float. How can I keep the number in the format that it is in in the excel spreadsheed? Any help would be greatly appreciated!MirandaMiranda Hoskins |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-01 : 11:36:26
|
| Create the new table first with the datatype you want, and then use DTS to import the spreadsheet into the table.CODO ERGO SUM |
 |
|
|
|
|
|
Datatype