query SQL Server Data to be inserted into Access table

C

chuayl

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
 
M

[MVP] S.Clark

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

chuayl

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