TicketMan
asked on
How to create a parameter in an APPEND SQL statement to get the database location?
Hi Experts,
I have a fairly straightforward append sql statement within MS-Access 2003 (having used its SQL visual designer) in the form of:
INSERT INTO [tableA] ( field1, field2, ..., ...) IN 'C:\TicketMan\DATABASE\Eve nts Storage\events.mdb'
SELECT ( field1, field2, ..., ...) FROM [tableX];
Instead of having the database file path/name hardcoded within the SQL, how do I create a parameter for it?
Thanks!
I have a fairly straightforward append sql statement within MS-Access 2003 (having used its SQL visual designer) in the form of:
INSERT INTO [tableA] ( field1, field2, ..., ...) IN 'C:\TicketMan\DATABASE\Eve
SELECT ( field1, field2, ..., ...) FROM [tableX];
Instead of having the database file path/name hardcoded within the SQL, how do I create a parameter for it?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER