joemeshuggah
Board Regular
- Joined
- Jul 18, 2008
- Messages
- 161
I have an Excel file that runs a query via VBA...I would like the results to either replace or append the prior day's results in a particular text file saved on a local drive. Does anyone have VBA code to do this?
Also, is it possible to do both DDL & select queries in one query, or, as the error message "Only an ET or null statement is legal after a DDL statement" seems to indicate, do these need to be kept separate? A good portion of my queries rely on temporary tables that need to be created preliminarily.
Also, is it possible to do both DDL & select queries in one query, or, as the error message "Only an ET or null statement is legal after a DDL statement" seems to indicate, do these need to be kept separate? A good portion of my queries rely on temporary tables that need to be created preliminarily.
