I'm able to copy a table from one Access mdb file to to another Access file using: (Answer from this forums a long time ago)

"SELECT * INTO students IN 'C:\myaccess.mdb' FROM students"

Meaning I copy the whole table students from the current connection access database to another access database file.

How can I copy a table from an external access mdb file to the current SQL Server connection?

Thanks in advance!

Mike.