Aah!! A serious case of cross wires here, my bad. When you said "I got the desired results" i immediately assumed it was the OP saying they had resolved the issue :p My sincerest apologies And as i said, i assumed the CAPS were accidental.

The fact that you have run the same query and got the desired results most likely confirms what i said; the data connector is mis-casting the column and returning empty strings when it fails to cast the strings to the wrong type. I have apps that retrieve emaila ddresses just fine from excel files so i cant see it being the special characters at fault. Guess we just have to wait for the OP to post their excel file correctly

This is a little confusing to me... What happened to venkates.99, who started the thread? I see vksingh.24 saying the problem is solved--are the two of you working as a team or something?

If there is still a problem, let us know what it is because there is no uploaded spreadsheet to test with. The data sample-text provided does not cause any problem for me when put into a new sheet with no other values present in the sheet.

Otherwise, if the problem is solved, please update the thread to SOLVED. Thanks.

EDIT: I missed the last post by Ryshad--didn't notice page 2. Anyway, I guess we are all waiting to hear back from vksingh.24.

I am not working as a team with venkates.99. I think venkates is yet to confirm about his problem.

Thanks!

HI D,
I have solved this.I need more info about some other problem
i.e.

I need to load data from DataGridView/dataset to Excel via Save as Dialog box, and vice varsa,
i.e need load data from Excel to DataGridView/dataset via Open dialog box.

Please give a solution

Thanks
Venkat.

If your original problem is solved, please mark this thread as solved and create a new thread for your new question. I think this thread has become confusing enough as it is without piggybacking a new problem on top