Advertisement

11.14.2007 at 12:39PM PST, ID: 22961229
[x]
Attachment Details

DTS: SQL to Access.mdb, INSERT INTO all_tables_destination SELECT all_tables_source WHERE...

Asked by jimhorn in MS SQL DTS, Microsoft Access Database, MS SQL Server

Tags: insert, access, sql, select

Hi All

I have a SQL2K db and an A2K.mdb, both have the same schema.  
(The mdb tables were the 'source' of creating the SQL tables.)

I need to do an INSERT of all records in all tables of the SQL2K source, INTO all tables in the A2K.mdb, WHERE a column = a passed value.

For the moment, I would prefer to avoid using Access VBA code and linked tables to do this, unless there are no other practical options.

My knowledge of DTS is limited to simple data transfer tasks from one source to another.

TIA
JimStart Free Trial
 
Keywords: DTS: SQL to Access.mdb, INSERT …
Title
1 DTS
2 DTS Expert
3 VBA Code to run a DTS Package from …
4 Excel Import DTS tasks
5 Insert Error on SQL DTS Import
6 what is dts?
 
Loading Advertisement...
 
[+][-]11.14.2007 at 12:48PM PST, ID: 20283665

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.14.2007 at 01:03PM PST, ID: 20283795

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.14.2007 at 01:14PM PST, ID: 20283905

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.14.2007 at 01:39PM PST, ID: 20284141

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL DTS, Microsoft Access Database, MS SQL Server
Tags: insert, access, sql, select
Sign Up Now!
Solution Provided By: mshaebanyan
Participating Experts: 4
Solution Grade: A
 
 
[+][-]11.14.2007 at 03:29PM PST, ID: 20285021

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.15.2007 at 12:45AM PST, ID: 20287672

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.27.2007 at 07:52AM PST, ID: 20358738

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.27.2007 at 06:13PM PST, ID: 20362747

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.28.2007 at 07:21AM PST, ID: 20366033

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.29.2007 at 02:56AM PST, ID: 20372600

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.29.2007 at 07:08AM PST, ID: 20374080

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.29.2007 at 06:09PM PST, ID: 20379289

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628