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.

Advertisements

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.

    http://www.howinexcel.com/?p=7

    Like

    Reply

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 19 other followers

Archives

Top Rated

Top Clicks

  • None

Blog Stats

  • 168,726 hits

%d bloggers like this: