Run Access query with a DTS?

[balistikb]

I have a DTS that runs a few commands. One of those commands that I want it to run is to run an Access query. I guess this might be an activeX task but I don't know how to do it. I am a beginner so I don't know where to begin. Oh also the DB has a password to enter.
Thanks in advance for any attempt to help.

 

[BuGlen]

If you're looking to import access data based on specific column values in the access table, you can do so directly in the Transform Data task.

Simply specify an SQL Query on the source tab instead of the Table / View option. You can use the Build Query button to visually create your source query as well.

Hope this helps.

- Glen

Know thy data.

 

[balistikb]

Actually, I need to run two queries before I import a database. Can the be done?