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

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!Migrating Access databases to SQL Server can be done different ways from
both sides. Also, depending on the version of SQL Server that you target you
can use different tools too.
Here are a few links that will give you a good start:
SQL Server Migration Assistant for Access (for migrating databases from
Microsoft Access versions 97 through 2003 to Microsoft SQL Server 2005):
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
Moving Your Access 2002 Database to SQL Server 2000 (look at the Data
Transformation Services section for importing Access data to SQL Server):
http://msdn2.microsoft.com/en-us/library/aa902657(SQL.80).aspx
How to use the Upsizing wizard in Access 2002:
http://support.microsoft.com/default.aspx/kb/330468
Access 2002 Upsizing Tools white paper:
http://support.microsoft.com/default.aspx/kb/294407
In the past I have used many times the Data Transformation Services in SQL
Server 2000 to import data from Access databases and it has been working
very well. Recently I used the SQL Server Import and Export Wizard in SQL
Server 2005 to import a few tables from .mde files and no problems there
too.
Regards,
Plamen Ratchev
http://www.SQLStudio.com|||<dba_222@.yahoo.com> wrote in message
news:1169516295.667810.162270@.51g2000cwl.googlegroups.com...
> 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!
>|||you should use DTS or something similiar in order to import all of your
Access Databases into SQL Server
"la playa mas bella" <thepadrino_1@.hotmail.com> wrote in message
news:eSt2kaXgHHA.588@.TK2MSFTNGP06.phx.gbl...
> <dba_222@.yahoo.com> wrote in message
> news:1169516295.667810.162270@.51g2000cwl.googlegroups.com...
> > 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!
> >
>