Middlebury

Difference between revisions of "Excel To SQL"

Line 1: Line 1:
===Copy from Excel, pasted into text editor===
+
#Copy from Excel, pasted into text editor
===Escape single quotes===
+
#Escape single quotes
Find <code>'</code>
+
#* Find <code>'</code>
Replace <code>\\'</code>
+
#* Replace <code>\\'</code>

Revision as of 11:58, 5 October 2007

  1. Copy from Excel, pasted into text editor
  2. Escape single quotes
    • Find '
    • Replace \\'