Using a DTS from Access

S

schasteen

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.
 
D

David Lloyd

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.
 

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

ASK Field Formatting 1
Creating a Chart on form from selected data in query. 0
Microsoft Access – SQL Server DTS 1
Calling DTS from Access - URGENT PLEASE HELP 1
Blank Page After Envelope-Label Wizard 5
Page numbering with Merged Document and IF statements 1
Integrating information from Word to Excel (not mail merge) 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top