Attaching MS Access tables

[squonk]

I'm having a little difficulty attaching an MS Access db to an MS SQL server db.&nbsp;&nbsp;I have tried using the sp_attachdb command, which returns a message that the header is invalid.&nbsp;&nbsp;The same message is returned when I try to attach anything besides an SQL db, so I would assume that the problem is that the procedure I'm using is for sql db's only.<br><br>Thanks,<br><br>Bill Nesting<br><A HREF="mailto:bill@ccservices.com">bill@ccservices.com</A>

 

[ColinM]

You have to add a linked server<br>To do this go into Enterprise Manager and go to the Security tab, then linked server.<br>Create a new one with the jet driver.<br><br>