Adding data to database using excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • chirag1989
    New Member
    • Jan 2008
    • 28

    Adding data to database using excel

    how can i add data to database using excel through asp
    actual i wanted to use datagrid but as its not supported
    by asp so i want to try dat by excel
    can any one just provide me a short code
    about how to relate excel wid database tabel
  • CroCrew
    Recognized Expert Contributor
    • Jan 2008
    • 564

    #2
    Hello chirag1989,

    I think I understand what you’re asking.

    Is it that you want to connect to a database (MS-SQL, Access, MySQL, Ora) then display the results of a query within an Excel workbook. Then allow a user to edit the results that are within that Excel workbook and update the database that it came from all within Classic ASP?

    Am I right?~

    Comment

    • chirag1989
      New Member
      • Jan 2008
      • 28

      #3
      Originally posted by CroCrew
      Hello chirag1989,

      I think I understand what you’re asking.

      Is it that you want to connect to a database (MS-SQL, Access, MySQL, Ora) then display the results of a query within an Excel workbook. Then allow a user to edit the results that are within that Excel workbook and update the database that it came from all within Classic ASP?

      Am I right?~
      yes this is wat i want to do
      but how

      Comment

      • CroCrew
        Recognized Expert Contributor
        • Jan 2008
        • 564

        #4
        You can do everything but the updating from Excel within ASP. Unless someone knows a way that you can.

        Comment

        Working...