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 |
|
themark712
Starting Member
5 Posts |
 Posted - 2002-03-01 : 15:59:43
|
| Does anyone know how to write a either stored procedure that will export SQL Server table data to Access 2000? |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-03-01 : 16:18:17
|
| There are many ways to get data in SQL Server to be available in Access, and they don't all relate to stored procedures. Here are a couple of ideas:1) In Access use Get External Data... Link to link to the SQL Server tables directly and query/report on them. This means no export needed, and always seeing the most current data.2) Use DTS in SQL Server to Export the data to Access. You can run a DTS package by issuing the command-line command DTSRun... Or you can put that into a sproc, or even a scheduled job if you want to.3) Create a Linked Server connection in SQL Server from SQL to Access and act on the tables in Access directly.------------------------GENERAL-ly speaking...Edited by - AjarnMark on 03/01/2002 16:19:14 |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-01 : 16:18:26
|
| Use DTS. Much easier.-Chad |
|
|
|
Jay99
468 Posts |
Posted - 2002-03-01 : 16:34:55
|
| add a linked server (sp_addlinkedserver) or create a dts package and call that from your proc (either via a job . . . sp_start_job . . . that runs the package or by calling DTSRun directlyl from an xp_cmdshell)JayEDIT: damn two replies before I can even post . . .Edited by - Jay99 on 03/01/2002 16:36:17 |
|
|
|
|
|
|
SQL Server To Access Export