Using a DTS from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking at upgrading a database to SQL Server and was looking at using a
DTS to transfer data from a text document to the table. I am using Access as
the front end and would like the user to click a button to start the
transfer. Is this possible, and how would it be accomplished? Any help will
be appreciated.
 
If you are just looking to execute an existing DTS package from Access, the
following KB article may be useful.

http://support.microsoft.com/default.aspx?scid=kb;en-us;315661

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am looking at upgrading a database to SQL Server and was looking at using
a
DTS to transfer data from a text document to the table. I am using Access
as
the front end and would like the user to click a button to start the
transfer. Is this possible, and how would it be accomplished? Any help
will
be appreciated.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling DTS from Access - URGENT PLEASE HELP 1
MS DTS Object Package Library 1
How to export table from outlook into ms access table? 0
DTS WIZARD alternatives? 0
DTS doesn't update AutoValue fields 1
Executing a DTS Package from Access 2003 (Visual Basic) 2
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Useing SSRS (SQL Reports) with Access 2

Back
Top