locked
Import Data RRS feed

  • Question

  • How can I import data from Micrsoft Excell speadsheets to SQL 2008  database?
    Friday, October 22, 2010 9:55 PM

Answers

  • Hi,

    Please find below some of good links.

    How to import data from excel to SQL Server

    http://support.microsoft.com/kb/321686

    Apart from this we can use IMPORT DATA WIZARD, it will ask for Data Source, we can select Excel (currently its recognising files of Excel 97-2003 version, office 2010 is not recognised at this time).

    HTH


    Regards Gursethi Blog: http://ms-gursethi.blogspot.com/ ++++ Please mark "Propose As Answer" if my answer helped ++++
    • Proposed as answer by Tom Li - MSFT Tuesday, October 26, 2010 9:44 AM
    • Marked as answer by Tom Li - MSFT Tuesday, November 2, 2010 8:38 AM
    Saturday, October 23, 2010 4:59 AM

All replies

  • Is that a 32 bit SQL or 64 bit SQL?
    Did you try Import Wizard? OPENQUERY can also be used by using Jet provider.


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Saturday, October 23, 2010 3:02 AM
  • Hi,

    Please find below some of good links.

    How to import data from excel to SQL Server

    http://support.microsoft.com/kb/321686

    Apart from this we can use IMPORT DATA WIZARD, it will ask for Data Source, we can select Excel (currently its recognising files of Excel 97-2003 version, office 2010 is not recognised at this time).

    HTH


    Regards Gursethi Blog: http://ms-gursethi.blogspot.com/ ++++ Please mark "Propose As Answer" if my answer helped ++++
    • Proposed as answer by Tom Li - MSFT Tuesday, October 26, 2010 9:44 AM
    • Marked as answer by Tom Li - MSFT Tuesday, November 2, 2010 8:38 AM
    Saturday, October 23, 2010 4:59 AM
  • Hi Balmukund

    >OPENQUERY can also be used by using Jet provider.

    Did you mean linked server to EXCEL? Does MS release JET for 64 bit?

    Openquery cannot have a provider name, am I right?

     


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, October 25, 2010 8:13 AM
  • Any progress?
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, October 26, 2010 6:20 AM