Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
 Posted - 2005-04-06 : 09:11:25
|
| Is there any query that we can run from SQL Server2000 that will export data to Access Table? MadhivananFailing to plan is Planning to fail |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-04-06 : 09:23:43
|
DTSOrCreate the Access DB as a linked server and do it that wayAndyBeauty is in the eyes of the beerholder  |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-04-06 : 09:24:40
|
| Your least painful route is probably just to use DTS. You could also take a look at opendatasource or set up a linked server and do the insert. It really depends on the frequency you need to do this, whether your query changes each time you need to do it, and how many records you're dealing with. If it's a static process, DTS is probably sufficient. If it needs to be more dynamic than you may want to consider a linked server and write dynamic sql to do the insert. If you provide more details we can pinpoint a better solution for you.Mike"oh, that monkey is going to pay" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-04-06 : 09:40:41
|
| I used the following queryINSERT INTO OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0','Data Source="D:\Test.mdb"; User ID=Admin;Password=' )... SQL(no)SELECT no FROM tt1 The Message (16 rows(s) affected) displayed. But actually data is not added to access table Any errorMadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-04-06 : 09:42:18
|
quote:
Originally posted by AndyB13
DTSOrCreate the Access DB as a linked server and do it that wayAndyBeauty is in the eyes of the beerholder
Andy Can you give an example?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
SQL Server2000 to Access