Sir,
I have made an application to read data from an excel file and save to database "Access". It's working perfect except one thing that:
There are 4 columns in excel file as :
- Shop no
- owner address
- alternate member address
- permanent member address
For all fields i have kept same datatype in database as "text". As in above image In Column A "shop no" in some rows there are same shop no with A,B,C classes.
Now when I am uploading this excel file it saving all data, but in Column A cells which having only numbers would be saving to database eg: 185, 187, 188. And the cells which has both number and class eg: 185 A, 185 B would be reading as null values. why?
any suggestions would be helpful.......
