I use Pass-Through queries.
Mostly for select or Stored Procedures.
I would like to use it to append data to a Server table. However the data I'd like to append is from a local Access table.
Can I and how do I, if possible, write the T-SQL in an Access query that will identify where the local table it and the Server table is?
I would appreciate any help you could give me.