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 SkipVought 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
0
0
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

marydn
  • Locked
  • Question
Send Nicely Formatted SQL Query via Email
Replies
0
Views
112
marydn
marydn
Cpreston
  • Locked
  • Question
Update File with only new records
Replies
1
Views
65
fredericofonseca
fredericofonseca
Vronsky
  • Locked
  • Question
SSIS importing flat file (CSV)
Replies
0
Views
65
Vronsky
Vronsky
arunaramana
  • Locked
  • Question
use case to 'Name and Extension', 'Full Qualified' and 'Name Only' options in foreach file enumerato
Replies
0
Views
59
arunaramana
arunaramana
appelq
  • Locked
  • Question
SSIS import from CSV is truncating the Decimal 1
Replies
2
Views
123
appelq
appelq

Part and Inventory Search

Sponsor

Back
Top