-
In addition to this What excel does is it checks for first few columns and excel connection manager just blindly assigns a data type. In your case the datatype assigned in Integer for the column so you cannot have 9,13 in iteger field and hence You have no data in that fields.
In MS EXCEL Format the column as TEXT and re create connection manager for this and you should get the results.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|