Pass-Through Queries for Input/Append

• Ken at work

  Hall of Fame

  Points: 3426

  More actions

  April 6, 2010 at 8:07 am

  #73497

  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.

• Koncentrix

  Old Hand

  Points: 338

  More actions

  April 17, 2010 at 8:42 am

  #1153338

  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