Problems with values when importing XLS into SQL

[ninel]

I have an xls file that needs to be imported into SQL Server directly from .net.
I figured out how to do this, but now my problem is the data. The following data is in the xls file: Name, Address, City, State, Zip, Phone

The phone number can come in in various values(with dashes and without). I have no way of controlling this data because it is an export out of some third party application. My problem is that the numbers with the dashes are being ignored by the Excel import.

I am using the OPENROWSET to import.

Can someone please help me?

Thanks,
Ninel

 

[cjard]

does openrowset have a connection string where you can set the IMEX=1 extended property? See ConnectionStrings.com - Forgot that connection string? Get it here! for more info on excel connections strings