Executing MS-Acess queries from a text file
-
I have a set of ms-access queries in .txt file. How can i execute those queries from a vb program? -- modified at 4:11 Friday 11th November, 2005 I have got the code to execute the query from the text file but if a query spreads across more than one line i am getting a problem because i am using an array that stores each line in the database and executes it. can u suggest how i can use a delimiter to indicate the end of a query or an alternative. Another problem is that i want to execute queries from many txt files. Right now i have hard-coded the path of one of the text files. I want to access each query sequentially( the user can't select) and i am working in vb 6 so kindly help Please help. Thanks in advance -- modified at 6:09 Friday 11th November, 2005
-
I have a set of ms-access queries in .txt file. How can i execute those queries from a vb program? -- modified at 4:11 Friday 11th November, 2005 I have got the code to execute the query from the text file but if a query spreads across more than one line i am getting a problem because i am using an array that stores each line in the database and executes it. can u suggest how i can use a delimiter to indicate the end of a query or an alternative. Another problem is that i want to execute queries from many txt files. Right now i have hard-coded the path of one of the text files. I want to access each query sequentially( the user can't select) and i am working in vb 6 so kindly help Please help. Thanks in advance -- modified at 6:09 Friday 11th November, 2005
VB6 Is this a list of queries to be accessed sequentially, or do you need to select? Basically read the query from the file into a string, or string array depending on what you need to do, and then execute the appropriate string. If you need more help I can assist if it is VB6