none
How to insert data from excel sheet to database with VBA? RRS feed

  • Question

  • I need to insert the data from an excel sheet into a database. and I need this to be done using a MACRO. I have data in excle sheet like this

    Name                            Value              Date

    12345_ABC_DefGeh       12345678        01.11.2018

      ......so on around 15 values.

    with this name i enter into database which provides ID for this name and with this ID we can get access the required table then in this table we need to change the value and dates. So what i have done sofar i maintained a connection with database i could reach through this given instrument and could reach the exact place but problem is to insert these two values and to connect this excel sheet.

    Best Regards,

    Sajjad





    • Edited by Sajjad05 Friday, February 1, 2019 2:30 PM
    Friday, February 1, 2019 1:56 PM

All replies

  • I'd like to ask you to:
    (1) explain more specific what "database" is.  Is it Access DB, SQL DB, or Excel database?
    (2) provide your code.

    Ashidacchi -- https://ssl01.rocketnet.jp/hokusosha.com/default.html

    Saturday, February 2, 2019 3:13 AM
  • Thanks alot for your support.



    • Edited by Sajjad05 Tuesday, February 5, 2019 11:51 AM
    Monday, February 4, 2019 11:07 AM
  • Hi Sajjad05,
    Thank you for providing information and code.
    But, sorry, I don't have SQL Database and cannot answer.
    Regards,

    Ashidacchi -- https://ssl01.rocketnet.jp/hokusosha.com/default.html

    Tuesday, February 5, 2019 1:46 AM