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 |
|
endir
Starting Member
4 Posts |
 Posted - 2006-09-27 : 11:18:53
|
| HI,i am working with microsoft SQL server 2000 with multiple databases.i need to work with different tables from each database. in this i use microsoft access to elaborate some daily work. the export of some tables from one database takes me time (finding them, controlling them etc). this data export i have to do it for 20 databases.is there any way to create a script to make possible the export from SQL server directly to access databases using the script section of the DTS export wizard or without using it???????thank you in advanceEndir |
|
|
endir
Starting Member
4 Posts |
Posted - 2006-09-29 : 10:29:42
|
| Can sombody help me with this?????Insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'd:\testing.mdb';'admin';'', region)select *from [region]i have to create the table in the mdb file and still does not copy the nvarchar data (the int yes).Syntax error converting the nvarchar value 'Easternis there any possibility that i can copy the data in the mdb file????? |
 |
|
|
|
|
|
export tables to access