Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CSV file escape phone number format

Status
Not open for further replies.
lavadan

lavadan

Programmer
Dec 17, 2007
49
US
I have a CSV file converted from excel. The phone numbers in the csv file looks like 8887964532.

But when I import the data into sql using import wizard, the phone number is converted to +18887964532.

+1 is added infront of all Phone numbers. Is there a way to escape this?



 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
CSV to SQL table with not allow null issue
Replies
3
Views
372
Cpreston
Cpreston
marydn
  • Locked
  • Question
Send Nicely Formatted SQL Query via Email
Replies
0
Views
397
marydn
marydn
Cpreston
  • Locked
  • Question
Update File with only new records
Replies
1
Views
290
fredericofonseca
fredericofonseca
Vronsky
  • Locked
  • Question
SSIS importing flat file (CSV)
Replies
0
Views
219
Vronsky
Vronsky
arunaramana
  • Locked
  • Question
use case to 'Name and Extension', 'Full Qualified' and 'Name Only' options in foreach file enumerato
Replies
0
Views
227
arunaramana
arunaramana

Part and Inventory Search

Sponsor

Back
Top