complete newbie here. How do I link to an access table 1

[Rousseau10]

complete newbee here. How do I link to an access table?

thanks

I went to the DTS wizard and it started me setting up a data source. Do I need to do this? Any how I got stuck on the data source wizard window when it ask me what I want my default database to be OR attach database fileneame text box.
It seems so much simpler in access.

 

[dbomrrsm]

select an access connection and provide the path to the db you want then select a sql server conncetion and do a transform data task between the two - dead easy - much easier than access

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[Rousseau10]

it worked!!!!!!! tanks