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:57, 5 October 2007

Copy from Excel, pasted into text editor

Escape single quotes

Find ' Replace \\'