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.
