469,159 Members | 1,382 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,159 developers. It's quick & easy.

Using BULK upload, how to remove Space present in file

Using Bulk Upload ,we are uploading Data which present in files .but in Data file for some fields has extra space ,But Field length Eg: Char(1) ,Because Space Char(2).
How to resolve this issue.
Jun 6 '12 #1
1 2215
ck9663
2,878 Expert 2GB
Use a Format File to upload your data and use the VARCHAR data type instead.

Good Luck!!!


~~ CK
Jun 6 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Ruddy | last post: by
2 posts views Thread by Tobes \(Breath\) | last post: by
8 posts views Thread by Joseph | last post: by
1 post views Thread by Azkaban | last post: by
8 posts views Thread by John Salerno | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.