Migrate / Read Access data file(s) in SQL Server

[dba_222]

Dear Experts,

I have some Access .mde files from a custom application.

The runtime version of Access is 2002. I don't have
a developer's version of Access. I also don't have the
schema design of the app.

I'd like to import or migrate the data file into SQL Server
schemas (databases) somehow. Or, another database
like Oracle.

Is it possible to do this from SQL Server?
What is the buzzword that I can search on?
Is there a link you can forward?

Thanks a lot!

 

[Baz]

The SQL Server Data Transformation Services can import data from Access
tables.

 

[la playa mas bella]

Dear Experts,

I have some Access .mde files from a custom application.

The runtime version of Access is 2002. I don't have
a developer's version of Access. I also don't have the
schema design of the app.

I'd like to import or migrate the data file into SQL Server
schemas (databases) somehow. Or, another database
like Oracle.

Is it possible to do this from SQL Server?
What is the buzzword that I can search on?
Is there a link you can forward?

Thanks a lot!

 

[Susie Johnson]

you should use DTS or something similiar in order to import all of your
Access Databases into SQL Server