Creating a SQL Table from an Access Table and a SQL Table

[wfairbanks]

I am wanting to create a SQL table were I can pull my access data and data from another SQL table and put it into one SQL table with the data in the one SQL table updating itself as the other two tables are updated. I am aware that I can create an Inner Join to link two tables into one in SQL but can one of those tables also be an access table?

Many questions and all one thought............

Desperately needing help or good resource books.

Thanks,
Wendy

 

[hubud]

I think I follow you. Try importing the whole access table into sql server. Then set this table as a linked table to access so you can still access this from access.
Once it's in sql server it shouldn't be a problem selecting from either.
You could use dts periodically to select * from both tables and set up a destination table within sql server populated by both these tables???

Does that help at all

simmo

 

[wfairbanks]

Sorry it has taken so long to reply. I think I understand wat you are saying. I am unclear about this part:

You could use "dts" periodically to select * from both tables and set up a destination table within sql server populated by both these tables???

I am not sure about the dts. What do you mean?

????

Thanks for your help!

 

[tEkHEd]

DTS is a Data Transformation Service, it is a package that will copy data, tables, views, stored procedures, databases etc from 1 SQL server location to another.

It is fairly simple to set up a DTS package provided that you have access to the source as then you can just follow the DTS wizard.

The DTS package can then be saved as a series of instructions on the server and scheduled to your hearts content