Click here to Skip to main content
15,883,827 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello,

I am importing data from excel to sql.
I am using the following connection string:-

excelconnectionstring = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties='Excel 8.0;HDR={1}'";

And in excel one coloum-data is in following form:-
WB/7225/X-123433

The problem is,when iam getting the data from excel to datatable,all data are coming in the datatable except the above form..please, tell me how can i correct the issue..
Posted
Comments
Nirav Prabtani 16-Apr-14 3:07am    
try to insert this data in that way

WB//7225//X-123433
ajays3356 16-Apr-14 3:17am    
Not working..

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900