Issue import Data From Excel to SQL Server 2005

Question

Hi I m importing Data from Excel to SQL Server 2005. It is Working fine. The problem is

1) In one full column of Excel i have some Raw information how to spilt those information and store in SQL fields.

2) There is Single quotes (') in many fields so how to convert those to as something like ('') before taking to SQL.

Answer 1

First export your Excel data to tab-delimited or CSV. Then make your changes using Perl or sed or an editor with a regex find and replace.