Middlebury

Difference between revisions of "Excel To SQL"

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

Revision as of 11:57, 5 October 2007

  1. Copy from Excel, pasted into text editor
  2. Escape single quotes:

Find ' Replace \\'