Thursday, August 30, 2012

Tech: Import Excel Data into a SQL 2012 Table

Importing Excel Data into a SQL Table

Using the built-in Import and Export Data  Utility


Importing data into a Microsoft SQL Server Database Table can be a little tricky.  Things have changed from back in the days where the DTS packages were easy to configure (although SSIS is a more powerful alternative),  if you want a very simple, very fast way to import data into your SQL Server Database from a Microsoft Excel file this is an extremely quick and easy way to do it.

The first thing to note, and this is very important, is that the 64-bit import tool does not natively open Microsoft Excel files.  

Choose the 32-bit tool.

icon
32-bit Import/Export Tool

When you open the Import/Export Wizard you will see the following dialogue box and will need to choose the data source.  If you do not see a Microsoft Excel option then you may have accidentally opened the 64 Bit version of the wizard.
choose_data_source
Once you have chosen Microsoft Excel as your data source the dialogue options will change and allow you to locate an excel file.  Browse to or type in the location of your excel file.

Choose_data_dource_b

Choose the database server and the database you wish to connect to.

Choose_destination
If you need to add additional parameters or logic into the import, or want to import into an existing table based on existing data you can write a query to specify a data transfer.  I'll cover that in another article but for now we are just going to import the data into a new table.
Specify_table_query

You will then be given an opportunity to either select a table in which you can import the data, or create a new table.  I've created a new table called New_Contact_Table.
Select_tables

The import can then be imported immediately or it can be saved as a SSIS package which could be executed on a schedule or again at a later point in time.
Save_and_run

The confirmation reiterates the configuration changes that you've selected.
Complete_confirmation

When you click the finish button the status screen will show the progress, and if all goes well it will indicate that the data was exported properly into the database.
Successful_execution

Finally as you can see the 9200 rows that were imported are verified.

query_test_result


From this point you can simply manipulate the data into an existing table or if you just needed the data imported into a SQL server then your job is done.

This is a fairly simple process and I hope to create a short YouTube Video detailing the process in the next few days.

I have created a new video dealing with this process here.



~Yati


66 comments:


  1. Much obliged to you for requiring significant investment to give us a portion of the valuable and restrictive data with us.
    Regards,
    Excel Advanced Training | MS excel Training in Chennai | Excel Macro Training in chennai

    ReplyDelete
  2. Impressive blog with useful content, The way of explanation about SQL was really superb. Thanks a lot for share such a nice articleLinux Training in Chennai | Unix Training in Chennai | Python Training in Chennai

    ReplyDelete
  3. The post is written in very a good manner and it contains many useful information for me. Microsoft Excel Training Courses Malaysia

    ReplyDelete
  4. Thank you so much for sharing this great blog.Very inspiring and helpful too.Hope you continue to share more of your ideas.I will definitely love to read. TutuHelper

    ReplyDelete
  5. Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. Download iOS 11.3

    ReplyDelete
  6. I stumbled upon this blog with a host of new possibilities to explore. Thank you for the friendly in sharing. TutuApp VIP

    ReplyDelete
  7. Thanks for sharing the details! thanks for sharing information,nice article.
    i would like to more information from your side!
    please added more then tips!Am working in
    Excel Training in Hyderabad

    ReplyDelete
  8. Your Blog is really Nice and Informative..Thanks for sharing such a interesting article..keep updating..I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work.

    Java Project Center in Chennai | Java Project Center in Velachery

    ReplyDelete
  9. Good website! I truly love how it is easy on my eyes it is. I am wondering how I might be notified whenever a new post has been made. I have subscribed to your RSS which may do the trick? Have a great day! for grammarly trial click here

    ReplyDelete
  10. In the beginning, I would like to thank you much about this great post. Its very useful and helpful for anyone looking for tips. I like your writing style and I hope you will keep doing this good working.
    Hacking Course in Chennai
    Hacking Classes in Chennai
    AWS Training in Chennai
    Data Science Course in Chennai
    Digital Marketing Course in Chennai
    Hacking Training in Tambaram
    Hacking Training in Velachery
    Hacking Training in OMR

    ReplyDelete
  11. TutuApp APK iOS Free Download Latest Version 2019 Best Version Free! here And Also more...
    TutuApp
    TutuApp Download
    Snaptube PC Windows
    Tubemate

    ReplyDelete
  12. Thanks for your informative article. Android SDK allows you to create stunning mobile application loaded with more features and enhanced priority. With basis on Java coding language, you can create stunning mobile application with ease.

    Regrads,

    Advanced Excel Training in Chennai | Advanced Excel Training Courses in Chennai | Advanced Excel Certification Training

    ReplyDelete
  13. This comment has been removed by the author.

    ReplyDelete
  14. "The information is meaningful and magnificent which is shared here about the article. I really thank you for such a innovative post. if you want to take training in android, then ratindia.com is best for you.
    Android classes in jaipur
    best android coaching in jaipur
    android training institute in jaipur

    ReplyDelete
  15. Thank you again for all the knowledge you distribute,Good post. I was very interested in the article, it's quite inspiring I should admit. I like visiting you site since I always come across interesting articles like this one.Great Job, I greatly appreciate that.Do Keep sharing! Regards, google maps alternatives

    ReplyDelete
  16. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
    app and you are doing well.


    Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery

    ReplyDelete
  17. Microsoft Excel is a powerful spreadsheet application, or workbook. A workbook is a computer application that allows a user to enter a series of numbers, along with other data. custom excel dashboards

    ReplyDelete
  18. us import export data I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article.

    ReplyDelete
  19. This article provided me with a wealth of information. The article is incredibly helpful and offers some of the most useful information. Thank you for sharing it with us. shipment data

    ReplyDelete
  20. NCH Pixillion Image converter 10.49 Crack is among the foremost reliable, easy. By means of this picture converter and, you will rework our records into forms for hosting on site Pixillion Image Converter Crack

    ReplyDelete
  21. You can check at Microsoft to gain full access to office 2011, I highly recommend you to find a product key to support the developer. Mac Office 2011 Product Key Crack

    ReplyDelete
  22. It s a very useful page. Thank you. 928e0cc0166af2af563b94e5465ab65c
    sancaktepe
    aglasun
    digor
    marmaris
    gole
    gurpinar
    tutak
    dogansehir
    kemer

    ReplyDelete
  23. It s a very useful page. Thank you. 156406dc24237358fcc545dc9367bae0
    nilufer
    savsat
    carsibasi
    mersin
    saruhanli
    yesilhisar
    samandag
    cesme
    ispir

    ReplyDelete
  24. Congratulations on your article, it was very helpful and successful. 91bc292877a91feae8fa48d7bd99f857
    numara onay
    website kurma
    sms onay

    ReplyDelete
  25. Thank you for your explanation, very good content. e4282a54977333011473c815481a3377
    define dedektörü

    ReplyDelete
  26. Thanks for your article. ae683180b534c684ce4c70df883353b7
    evde iş imkanı

    ReplyDelete
  27. download a professional video editor software like fl studio 21 crack

    ReplyDelete
  28. href="https://crackedpc.org/">https://crackedpc.org/

    ReplyDelete
  29. href="https://istanbulolala.biz/">https://istanbulolala.biz/
    EFİS

    ReplyDelete
  30. This comment has been removed by the author.

    ReplyDelete
  31. Every point you beautifully expressed. Every time I read your site, I'm in awe of your exceptional writing skills.Best CA Coaching Centers in Hyderabad


    ReplyDelete
  32. After reading your piece, I learned that it deals with the appearance of control. But I don't understand this notion at all. I'd appreciate additional information about this subject. Would you kindly supply it?Top CA Coaching Institute in Hyderabad

    ReplyDelete
  33. We appreciate you sharing with us this special and helpful information. Fantastic work. continue bloggingBest CA Coaching Centers in Hyderabad

    ReplyDelete