|
Home > Archive > MS SQL Server DTS > July 2005 > Converting formatting data FROM EXCEL to SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Converting formatting data FROM EXCEL to SQL Server
|
|
| Sivaraman.S 2005-07-21, 9:23 am |
| Hi all,
How to convert the field colomn value like 018.000 into SQL Sql server
data in the same format.(The custom format in EXCEL is 000.000)
regards,
Sivaraman.S
| |
| Axel Dahmen 2005-07-21, 1:24 pm |
| That depends...
you must consider that SQL Server is a data back-end, so it's only purpose
is to *store* data, not to *present* data.
If you want to store the data exactly the way you want to present it to
users, you must convert the values to VARCHAR.
On the other hand, if you must calculate using the data you've stored, then
use your presentation front-end to show the values as desired. This is the
correct place to do this anyway.
HTH,
www.sportbootcharter.com
Axel Dahmen
----------------------------
"Sivaraman.S" < SivaramanS@discussio
ns.microsoft.com> schrieb im Newsbeitrag
news:92D1B4C1-7E9C-4CCB-A8F2- 0F7CB1EC352F@microso
ft.com...
> Hi all,
>
> How to convert the field colomn value like 018.000 into SQL Sql server
> data in the same format.(The custom format in EXCEL is 000.000)
>
> regards,
> Sivaraman.S
|
|
|
|
|