query SQL Server Data to be inserted into Access table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You can use DTS to transfer the data to the Access table, but don't believe
that an such SQL code exists. That would sort of violate the whole standard
agreement about the SQL language to have something Access specific in there.
 
Thank you.

[MVP] S.Clark said:
You can use DTS to transfer the data to the Access table, but don't believe
that an such SQL code exists. That would sort of violate the whole standard
agreement about the SQL language to have something Access specific in there.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Example Of VBA SQL Statement 0
Append Access Data to SQL Server Table 12
How to create a table from SQL Server query result 3
What are the steps to fix damaged MDF files in SQL Server? 0
SQL Server and Access 2007 1
Execute SQL 1
Cannot insert new record into sql 2005 View from Access form 1
Access parameterised queries upsizing to sql server 2

Back
Top