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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Import From Access Script

Author  Topic 

db_sysadmin
Starting Member

27 Posts

Posted - 2006-10-18 : 09:03:01
Hi there,

I want to create a SP or some DTS module to import some access table to a SQL Server 2000 Database...it´ll be activated manually from some front-end app... What should I use? and where to find some info on how to do it?

Thanks a lot!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-18 : 09:16:39
If You want to do it periodically, then read about jobs in sql server help file

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

db_sysadmin
Starting Member

27 Posts

Posted - 2006-10-18 : 09:35:04
No, It will be executed as required... thanks for your response!
Go to Top of Page
   

- Advertisement -