Newbie question. I've managed to create a SQL db, have a
MS access front end for running query/reports. Currently
I manually download data from source system to .txt file
and run a DTS to import into SQL.

Is is possible to run the DTS from Access? I'm just
beginning to understand the basics of VB...

Using SQL 2000 and Access 2000.

TIA,
tj

Are you running an mdb or an adp? If an mdb, you can import it
directly into a table and then run a local access query to load the
data. You can execute a DTS package from VBA (Access code), but if
you're working with an mdb FE that would be doing it the hard way.

--Mary

On Wed, 6 Oct 2004 14:59:25 -0700, "TJ"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Hi Mary,
I'm using an MDB.
So, the easier way would be to:
-load .txt file into temp table in the access MDB
- Run a query that uploads data into linked SQL table
Don't know if it matters but as an FYI my SQL table to is
6million records at this point in time (which is why I
moved it from Access)

tj

Are you using Access as the front-end for your application? If so,
then import the text file into an Access table the way you normally
would when the app was all-Access. Then create a pass-through query
that reads the data from the local table and appends it to the
appropriate SQL Server table. Since this is a process you run
regularly, once the imported data is in SQL Server, delete it out of
the Access table so you're ready for next time. You can automate this
using VBA code.

If you're not using Access as a FE and it's just hanging around from
your old app, you can eliminate it from the process by creating a DTS
package that will load the txt file into SQL Server. You can save the
package, and execute it on demand or on a schedule.

--Mary

On Thu, 7 Oct 2004 08:45:24 -0700,
<anonymous (AT) discussions (DOT) microsoft.com> wrote: