Link to home
Start Free TrialLog in
Avatar of TicketMan
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\Events 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!
ASKER CERTIFIED SOLUTION
Avatar of Jorge Paulino
Jorge Paulino
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TicketMan
TicketMan

ASKER

Thanks!