Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

HELP HELP HELP!!!!! execute a .sql file from C Program for MS Access d

amolchopraamolchopra Member Posts: 2
I have to automate the process of writing data to MS Access database. I have created a program that was executing the dynamically generated Insert queries in a for loop. This was taking very long to execute because of the bulk of the data and the number of for loop executions. I then created a .sql file and wrote all the Insert queries into the file and now plan to execute all the queries of this file as if I was batch executing the sql queries. Using MS Access database is my constraint and I have to use C programming language. Can someone please help me ASAP?

Comments

  • aatkbdaatkbd Member Posts: 42
    : I have to automate the process of writing data to MS Access database. I have created a program that was executing the dynamically generated Insert queries in a for loop. This was taking very long to execute because of the bulk of the data and the number of for loop executions. I then created a .sql file and wrote all the Insert queries into the file and now plan to execute all the queries of this file as if I was batch executing the sql queries. Using MS Access database is my constraint and I have to use C programming language. Can someone please help me ASAP?
    :
    :
    [blue]MS Access can't execute queries in parallel. Therefore, I don't see any advantage in creating a batch file.[/blue]
Sign In or Register to comment.