|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 28th, 2005, 01:19 AM
|
|||
|
|||
query SQL Server Data to be inserted into Access table
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 
|
|
#2
January 28th, 2005, 05:47 PM
|
|||
|
|||
|
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. -- Steve Clark, Access MVP FMS, Inc. www.fmsinc.com/consulting "chuayl" wrote in message ... 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
|
|
#3
January 31st, 2005, 01:25 AM
|
|||
|
|||
|
Thank you.
"[MVP] S.Clark" wrote: 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. -- Steve Clark, Access MVP FMS, Inc. www.fmsinc.com/consulting "chuayl" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Unmatched Query Mess | Natalia | Running & Setting Up Queries | 8 | October 28th, 2004 02:36 PM |
| Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
| Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
| Access and SQL | AHopper | General Discussion | 26 | August 3rd, 2004 07:01 PM |
| Useless Access 2003 | tired, angry, sucidial and bored | General Discussion | 10 | July 21st, 2004 11:52 PM |
Linear Mode
