Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts

    insert or update data via VBA Source excel to Sqlserver

    Hello experts !
    how to insert or update data of excel file (source) to sqlserver database. If row is already inserted than query go for update?

    i dont have any idea please help me out...


    Thanks alot
    farrukh

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Farrukh

    I'm not clear on what you need.
    Please let us know a little more.

    zeddy

  3. The Following User Says Thank You to zeddy For This Useful Post:

    farrukh (2013-03-23)

  4. #3
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Respected Zeddy,

    I am sorry that i cannot make all experts understand...
    I need a code that export data of excel sheet to sqlserver database. I can write a sql query if record already insert in a table then the query go for update record.

    Please share some examples that a vba code connect to sql server and export data of excel sheet to sqlserver database.

    Thanks
    farrukh

  5. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Farrukh

    see attached file.
    You should find what you need here.
    Please let us know if this helps.

    zeddy
    Attached Files Attached Files

  6. The Following User Says Thank You to zeddy For This Useful Post:

    farrukh (2013-03-23)

  7. #5
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Respected Zeddy,
    Exactly i am looking for this zeddy. Many thanks i always feel relax when i post any my problem on www.windowssecrets.com and find wonderful solutions.

    many wishes for you

    Regards,
    Farrukh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •