MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

ESSENTIALS: Home | Tips | Search | Categories | Top 10 | Products | Authors | Blogs | Forums | Webcasts | Advertise | About
Write query by using excel's parameters with parameter of cells of it - MSSQLTips

MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips
Welcome to MSSQLTips Sign in | Join | Help
in Search

Write query by using excel's parameters with parameter of cells of it

Last post 08-31-2008 4:37 AM by kris_erp. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 08-24-2008 10:03 PM

    Write query by using excel's parameters with parameter of cells of it

    Can anyone has idea to write query using excel like, Say I have 4 rows in excel,

            A              B                  C                    D

    1 Kishor            23              Diploma           Vansol

    2 Nayan            22              BCOM            Samarkha

    3 Ankur            23                S.S.C             Anand

    4 Swapnil         21                 BCA             Tamilnadu

    5 Jalo              24                M.B.A              Ukai

    Now in SQL I have 1 table Name as "User"

    Fileds are Name, Age, Degree, City

    Now These records I have in excel and I want to Insert this records from excel with diffrent type of condition using "Where", "Join" etc.. I am not talking about directly export records using Import-Export. If u have idea then please suggest me !!!!!!!!!!!!!!

  • 08-25-2008 12:52 PM In reply to

    • aprato
    • Top 10 Contributor
    • Joined on 12-01-2007
    • Greater Boston
    • Posts 296

    Re: Write query by using excel's parameters with parameter of cells of it

     There was a tip related to this last month

     

    http://www.mssqltips.com/tip.asp?tip=1540 

  • 08-31-2008 4:37 AM In reply to

    Re: Write query by using excel's parameters with parameter of cells of it

    Thanks a lot !!!!!!!!!

Page 1 of 1 (3 items)