How to copy a table from Access file to SQLServer

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.

SQL Server has a tool that would do that for you. It's called DATA TRANSFORMATION SERVICES. Very powerful imho.

So if you have the SQL SERVER MANAGER installed, you can use this to IMPORT/EXPORT different types of data IN and OUT of your SQL Server.

ARPRINCE,
I'm totally agree with you regarding the DTS in SQLServer. I forgot to mention in my previous post that, I would like to do it using VB6, ADO, connect to SQL Server. I'm building the client application, and the user may not have access to the Enterprise Manager.
Thanks!
Mike