im working on Server-client environment where i need to query data from MS
SQL to be inserted into MS access database whenever user prints report.

would like to know on the SQL Statement syntax on how to do that .

insert into <ms Access tbl> select ...... from <MSSQLTbl> ...

Thank you

Using what client? I'd guess you must be initiating this
from Access? There are different ways but you'd probably
want to post your question in an Access newsgroups.
One option would be to use a pass-through query to SQL
Server and use that as your source for an append query
(Access version of an insert query). The pass through query
would just do the query of the data from SQL Server.
But an Access newsgroup would be a better choice. You could
initiate it from SQL Server but it would likely be much more
convoluted than it needs to be.

-Sue

On Wed, 26 Jan 2005 22:43:01 -0800, chuayl
<chuayl (AT) discussions (DOT) microsoft.com> wrote: