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 |
|
roddy1212
Starting Member
4 Posts |
 Posted - 2005-06-29 : 16:10:45
|
| Hi,I generate a Focus file in TABT format (text format) and one of the fields (Part Number) lenght is 19 chars, but when the field is imported to the SQL Server Table it is getting trimed, which I don't want. This is the correct format to show...but if you see this part in the list that was import to SQL Table is only 10 chars lenght...It shouldkeep in 19 chars lenthgs...When I make the import the data type that I use is varchar(19)I also tested with Char(19) and it continues to trim the spaces between field...Pls. help...I need all the parts to be formatted as 19 charsSample of correct format...N60-2758 APART NUMBER Part Number Field LengthN60-2758 A 10 See correct lenght aboveX 836E DA1CC4-D4 A 18X 836E DA1CC5-D4 A 18X 836E DA1CC6-D4 A 18X 836E DA1EL4-D4 A 18X 836E DA1EL5-D4 A 18X 836E DA1EL6-D4 A 18X 836E DA1EN4-D4 A 18X 836E DA1EN5-D4 A 18X 836E DA1EN6-D4 A 18X 836E DA1EQ4-D4 A 18X 836E DA1EQ5-D4 A 18X 836E DA1EQ6-D4 A 18X 837E DA1BN3A4D4 A 19X 837E DA1BN4A4D4 A 19X 871P DD29NB140A2A 19X 898D N58PT-B5 B 17X 898D N58PT-T B 16X 898D P54PT-B10 B 18X 898D P56PT-B10 B 18X 898D P56PT-B5 B 17 |
|
|
|
|
|
Field is triming spaces - importing from text file