• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

export data to sql server

A

Afarag

Member
Hello,

please, developers, I ask for help, I have a sheet called "CMS" contains columns from ("A1:BC"). I need to export these data into my SQL server from A2 till last indexed row.

I want to use this sheet to stock data into SQL DB as when I update the data then migrate it I need to be stoked below the previous data without deleting the old stocked data or modifying it. I ask to stock data only from this sheet to SQL DB.

my SQL Info
Code: 
sConnString = "Provider=SQLOLEDB;Data Source=EGCAHCSGALT352\SQLEXPRESS;" & _
              "Initial Catalog=Table F;" & _
              "Integrated Security=SSPI;"

thanks a lot
 
You must log in or register to reply here.
Back
Top