How to Insert Excel file to SQ L Server 2005 or 2008

Discussion in 'microsoft.public.sqlserver.datamining' started by Wang Shao Yu, Oct 21, 2010.

  1. Wang Shao Yu

    Wang Shao Yu Guest

    Hi all,
    I am new with sql.
    Is there is a way how to insert excel file into sql server?

    this is the content in the excel file there are 3 columns studentName,
    StudentNumber and ProgramDescription.
    StudentName StuNum ProgramDescrip
    Abdel-Sayed, Michael A09630917 MTLLEA.AS- Programmeur Analyste
    Abdelhady, Hebatallah A09663260 MTLATP5802A- Pharmacy Technical
    Assistance


    Thank You
    Shao
     
    Wang Shao Yu, Oct 21, 2010
    #1
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.