Export Excel Spreadsheet into SQL Server 2005 Express database

Discussion in 'Webmastering & Programming' started by cismajor97, Oct 5, 2007.

  1. cismajor97

    cismajor97 [H]Lite

    Messages:
    88
    Joined:
    Mar 23, 2006
    I'm curious if there is an easy way to export an Excel spreadsheet into an SQL database? I have a project that I'm doing with a client of mine and it would be alot easier if I can organize and sort through this information.
     
  2. userjack

    userjack n00b

    Messages:
    43
    Joined:
    Sep 1, 2003
  3. PTNL

    PTNL [H]ardness Supreme

    Messages:
    4,190
    Joined:
    Jan 2, 2005
    With SQL Server Express, I don't think you get the SSIS importer that makes pulling from Excel, Access, or just about any common data source a breeze.

    One alternate suggestion I can think of is to write a DotNet app using Visual Studio 2005 Express (or better). You can query the Excel file with SQL and an ODBC connection, and get your dataset that way. Then you can iterate each row and do an INSERT statement to the destination database as needed. The SQL syntax itself is normally the same, with some subtle differences for data filtering and comparisons.
     
  4. cismajor97

    cismajor97 [H]Lite

    Messages:
    88
    Joined:
    Mar 23, 2006
    What I'm trying to do is Import Excel data into SQL Server Express 2005. Just wanted to clarify.
     
  5. PTNL

    PTNL [H]ardness Supreme

    Messages:
    4,190
    Joined:
    Jan 2, 2005
    One way for sure is to use the link provided by userjack, my previous post, and some Google-ing. SQL Server Integration Services (SSIS) is not an option because it does not come with the "Express" edition.

    If you don't have do much with business logic, data cleansing, etc., then a more direct way can be found from this link:
    http://www.mcse.ms/message2584507.html
    Haven't tried it myself, but it's worth a shot.
     
  6. cismajor97

    cismajor97 [H]Lite

    Messages:
    88
    Joined:
    Mar 23, 2006
    Thank you both. I'll give it a shot later on today.
     
  7. Monkey God

    Monkey God Mangina Full of Sand

    Messages:
    6,723
    Joined:
    May 7, 2007
    Im not familiar with the express edition, but the SQL management console has an import wizard, its very powerful.