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...