Pass-Through Queries for Input/Append

  • 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.

  • A Link from SQL Tables to MS Access should help joined both the local and the SQL objects.

    This should be an easy way for you to append data from ms access to sql table or vice versa.

    Thank you... Hope this helps...

    Koncentrix

    Koncentrix

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply