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 |
|
Rach2009
Starting Member
37 Posts |
 Posted - 2009-11-12 : 09:56:56
|
Hi,I'm currently trying to import some data in SQL Server from a csv file, but am encountering a few problems to do with how the data appears once imported into SQL itself. Particularly, I am finding that the import/SQL is adding in '0's to the start of codes whre there shouldn't be. For example, '58021923' is appearing after the import as '0058021923' and '123' is appearing as '0123'. Is there any way I can set up the data types to stop this from happening? I tried reducing the varchar sizes, but then I got an error message saying it the data was being truncated.Thanks!!!Rachel |
|
|
|
|
|
Data column format