[Access 2003] Multiple SQL Queries
Is it possible to run multiple queries in SQL (in access) separated by a semi-colon?
I have a large csv file without reference numbers and I am trying to match up the rows with another (larger) csv file that does have references.
I figured the easiest way to get the references would be to import the csv into access and run some SQL that matched up certain fields.
I can also create the queries in Excel by writing it once then using autofill down.
Unfortunately I can't seem to run them all at once.
Can you import queries from a text file?
Re: [Access 2003] Multiple SQL Queries
I have queries that I import from a text file. It is just a matter of reading the text file, storing what is in it in a string, and then executing that string (I'm using VB6 - should be able to do the same in VBA though)