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!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Apostrophe in extracted data interfering with code.
I am using the ExcelSQL add-in to extract data from a series of cells in an Excel worksheet and then push them into a SQL table. The problem I've run into is that if the text in the cell contains an apostrophe ('), SQL reads that as a break in the instruction code. For example, my code reads...- LacyLu42
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
