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 |
|
madhusudan
Starting Member
3 Posts |
 Posted - 2008-10-15 : 04:03:20
|
| hi, i need to write a stored procedure which actually transfers data from a table in a MS access Database to a table in SQL server.Request to help me out.I am new to writing stred procedures Done enough of digging google but no solutionMadhusudan |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-15 : 12:25:45
|
| You can use DTS packages. Did you try it? |
 |
|
|
jaynichols
Starting Member
18 Posts |
Posted - 2008-10-15 : 16:19:41
|
| In DTS setup a connection and an Access source. Connect them with a data transform task which will bring the access data into sql. Then setup an ExecuteSQL task which executes your stored proc. Connect the connection to the ExecSQL task with a success connection. If you can execute the dts from a job step or from a DTSRUN o/s command.Dirt biking forever! |
|
|
|
madhusudan
Starting Member
3 Posts |
Posted - 2008-10-15 : 21:24:21
|
| hi, i am completely new to this field of software , could you guys explain it in a bit more detail. PleaseMadhusudan |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-15 : 23:21:04
|
| Here you can learn about DTS package:http://www.devguru.com/features/tutorials/DTS/DTS2.asp |
|
|
|
madhusudan
Starting Member
3 Posts |
Posted - 2008-10-15 : 23:54:50
|
| hi sodeep, thank for the link.I have to take a look at it , i will do that and let you know if need anything else thanks for the prompt response :-)Madhusudan |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-15 : 23:57:20
|
| You can also see great site for DTS packages:www.sqldts.com. |
|
|
|
|
|
|
import MS access data to SQL table in stored proc