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.
Thank you, I looked at the other threads, but I'm having trouble adapting them to my situation. First, I am using an automate program to automatically extract the data. I have over 1200 excel files with 20,000 cells + each to interpret, so there's no way I can do them all by hand, converting...- LacyLu42
- Post #3
- Forum: Microsoft SQL Server: Programming
-
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
