locked
is possible to update a database from excel file? RRS feed

  • Question

  • User-352524747 posted

    Hello, 

    is possible to update a database from excel file? What i want to do is to update the database every time i add a new record in excel worksheet, automatically by runing a page that can get the last row of excel sheet and add it on database table.

    Thanks

    Tuesday, June 7, 2011 5:59 PM

Answers

All replies

  • User-736607127 posted

    Hi Dow7,

    Yes u can.

    Wednesday, June 8, 2011 12:06 AM
  • User-1696077569 posted

    This article of mine will get you started

    http://www.dotnetspider.com/resources/17599-Reading-Excel-into-Access-Database-Using-ADO-Net.aspx

    Wednesday, June 8, 2011 12:21 AM
  • User-821857111 posted

    I assume that you would like to add some kind of automation to the Excel workbook so that it connects to a web site and transfers the new data? If so, this forum is the wrong place to ask the question. You should try an Excel forum.

    On the other hand, you have to ask yourself why you are adding "records" to an Excel file in the first place if you actually want to store them in a proper database anyway. Seems a bit pointless to me.

    Wednesday, June 8, 2011 12:27 AM
  • User-352524747 posted

    Hi,

    i add first in excel because i have to calculate some data first. eg. i enter the usd price and want to calculate EMA12, EMA26, MACD... 

    i can't do it in a database, i don't know how :)

    I want to know if it is possible to enter new records in database faster not manually by copying each of them from excel.

    Thanks

    Thursday, June 9, 2011 5:55 PM
  • User-1694870838 posted

    Hi,

    Yes,you can.

    You can Use UDFs to Write to SQL Databases from Excel.

    Please refer to Luis's post:http://blogs.msdn.com/b/luisbeonservices/archive/2006/11/08/using-udfs-to-write-to-sql-databases.aspx

    Best Regards,

    Damon

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 13, 2011 9:56 PM