How to move data from an .XLS file into a SQL Server table?

Discussion in 'ASP .Net' started by Steve Kershaw, Dec 1, 2006.

  1. Hello,

    I need to move an Excell (.xls) table into a SQL Server 2005 table. How
    can I do this?

    thanks

    Steve
    Steve Kershaw, Dec 1, 2006
    #1
    1. Advertising

  2. Steve Kershaw

    dotnet_coder Guest

    You have to use SQL Server Business Intelligence Development Studio and
    Create a new Integration Services Project. Then used the Bulk Insert
    Control and import the Excel File to the table that you want.



    Steve Kershaw wrote:
    > Hello,
    >
    > I need to move an Excell (.xls) table into a SQL Server 2005 table. How
    > can I do this?
    >
    > thanks
    >
    > Steve
    dotnet_coder, Dec 1, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. DaveF

    Need to Import xls file into SQL?

    DaveF, Nov 22, 2004, in forum: ASP .Net
    Replies:
    3
    Views:
    14,681
    Scott Allen
    Nov 22, 2004
  2. bubberz
    Replies:
    1
    Views:
    520
    Steve C. Orr [MVP, MCSD]
    Aug 6, 2005
  3. TheVooDooChild
    Replies:
    2
    Views:
    7,672
    gaurav_magic
    Apr 20, 2007
  4. Harry Zoroc
    Replies:
    1
    Views:
    915
    Gregory Vaughan
    Jul 12, 2004
  5. Phillip Vong
    Replies:
    0
    Views:
    981
    Phillip Vong
    Dec 3, 2006
Loading...

Share This Page