472,107 Members | 1,316 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,107 software developers and data experts.

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 2278
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.