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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-12 : 08:34:34
|
| Oleg writes "I need to export selective data (selection criteria is provided for each instance, each instance is AdHoc event but happens more or less regular) from SQL Server to MS Access MDB. Can I and how do I it in a stored proc?" |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2001-12-12 : 09:21:35
|
| probably the easiest way to do it, would be through a DTS job. When the event fires, you can call a stored procedure which will then move the data from SQL to your Access database. Another method might be to use ADO as the medium between the two systems, but this largely depends on your interface and what exactly it is you're trying to do.Mike "A program is a device used to convert data into error messages." |
 |
|
|
|
|
|
Export data from SQL erver into Access MDB file