Import MDB File

I have a current Access 03 application that has a 3 tables that I would like to import, can this be done?

Davids Learning

You can't import mdb file to Sql server. but for alternative you can import data from acces 03 to sql server. the 1st, you must make new database & table (same with mdb file).

You can do, right click your db file in database manager, and then click import data. Please follow instruction from Sql......

Thanks

Jebat

Import error

I am attempting to import an access mdb file from a remote server.
When I run the import wizard I get the follwing error:
"Cannot start your application. The Workgroup information file is missing or
opened exclusively by another user."
I have checked to see if the lock file is there but its not.
Any ideas ?Not sure if this will resolve the problem but you can check the Advanced
properties of the the Access connection and edit the System Database value
to point to the location of the mdw file.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql