Change source/destination of Append Query on-the-fly?

[Zilla]

Hello,

Is it possible to have an existing append query prompt me for 1. a new
source table and 2. a new destination table each time it runs? The actual
fields on the source (csv import ) table and the destination (standard mdb
table) are always exactly the same - this is a regularly repeated process -
the only change is the name of the source and destination file, and of course
the actual data contained therein.

There are loads of fields involved in the append, so I cannot do a brand new
append each time, involving telling the query where to deposit each and every
field (lots of field name changes involved between source and dest!), so I
really need a way of automating this process as much as possible.

Ideally, I would have a parameter type pop-up asking me the name of the
source and destination file each time. Or better still, for it to
automatically make a copy of the 'clean' preexisting destination table (w/
new name) and automatically use this as the queries destination, and then
prompt me only for the source.


Hope i have been understood?!


Thanks in advance.

(if you want to throw vb at me in response to this - please go easy!)

 

[Steve Schapel]

Zilla,

I am sure this will be possible. But how are you going about this? I
got a bit lost between the tables and files. Are you importing into a
local table first, and then your Append Query takes it from there into
the main table? Or are you linking to the remote data to be imported?
Or are you referencing an outside database using the IN keyword? Maybe
it would help if you could post back with the steps you are taking, and
the SQL view of the Append Query as you have it so far, and this will
make it easier for someone to understand your specific requirement.