How to import Excel into MS SQL

September 17, 2009 at 11:45 pm 1 comment

First, forget about importing Excel into MS SQL, it is to time consuming to get it right. You are better of converting the Excel file to a simple CSV file, change the setting to a large string value for the columns, import it into MS SQL and then convert the field types to the proper field types.


Entry filed under: MS SQL. Tags: , .

Google Analytics with JavaScript disabled Google Analytics Qualification (Certification)

1 Comment Add your own

  • 1. samh  |  September 18, 2009 at 2:48 pm

    Another option is to generate SQL Insert statements within Excel.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 20 other followers


Top Rated

Top Clicks

  • None

Blog Stats

  • 170,012 hits

%d bloggers like this: