how to combine multiple sql queries in ms access
MS Access
SQL
Combining Statements (several into one)
I have several SQL statements...
CREATE TABLE A...
INSERT INTO TABLE A...
CREATE TABLE B...
INSERT INTO TABLE B...
CREATE TABLE C...
INSERT INTO TABLE C...
... and will add others. I would like to execute several in sequence and would like to know the best practice for combining multiple statements in MS Access.
SQL
Combining Statements (several into one)
I have several SQL statements...
CREATE TABLE A...
INSERT INTO TABLE A...
CREATE TABLE B...
INSERT INTO TABLE B...
CREATE TABLE C...
INSERT INTO TABLE C...
... and will add others. I would like to execute several in sequence and would like to know the best practice for combining multiple statements in MS Access.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 167 points for Phillip Burton's comment #a40365831
Assisted answer: 167 points for Phillip Burton's comment #a40365809
Assisted answer: 0 points for Henry Gage, Jr.'s comment #a40365820
Assisted answer: 166 points for Phillip Burton's comment #a40365829
for the following reason:
I included my comment as clarification of the questions and to keep a thread context.
Accepted answer: 167 points for Phillip Burton's comment #a40365831
Assisted answer: 167 points for Phillip Burton's comment #a40365809
Assisted answer: 0 points for Henry Gage, Jr.'s comment #a40365820
Assisted answer: 166 points for Phillip Burton's comment #a40365829
for the following reason:
I included my comment as clarification of the questions and to keep a thread context.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the comment. Is there also a way to combine the statements within MS Access without using VBA? I reason I am asking is because I want to run several as a group. For example I may want to drop or delete a table, create the table, load the table and export the table with one user event (on click).
Is your larger point that it is better to use VBA combined with MS Access because it enable a developer to govern the user experience by adding better UI controls, thus leading to an application?