Is there a way to run a job from SQL 2000 from Access 2003? I have tables that need to be renamed and re-imported in SQL from a txt file. SQL tables are then linked and used in Access. The txt file is short, but the SQL tables are too large for Access.

[Edited by gosamerone on 27-05-2008 at 07:19 AM GMT]

hi
what do you mean a SQL job?
Why trigger from Access?
you can use a sql passthrough query in access to exec an SP. is that what you need?
alternatively, you can exec a DTS package using VBScript (google), or you can shell to the Dulk import program (BPC).
any of these will acomplish what you need, however, I would question the need for any of these if the actual table cannot be accessed from Access.
regards
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

I asked about a job because that is what I have set up in SQL already. Also, I would need to trigger from Access because that is the front end.

The table is far too large for Access to handle effectively, but by running the txt file into the SQL table, then populating a temp table in SQL from a view that will reduce the data to what is needed, I can then link the temp table into Access. This process works, but is manual at this point.

I will research and try your suggestions. As always, I appreciate you response and help.

I was able to use the sql passthrough query and this should be enough to solve the problem.

Also able to run DTS - don't forget to add the
Microsoft DTSPackage Object Library


Thanks again.

[Edited by gosamerone on 02-06-2008 at 07:56 AM GMT]