Exporting MS Access to MS SQL

  • Thread starter Thread starter yisraelharris
  • Start date Start date
Y

yisraelharris

I have an MS Access database, which I want to export as an MS SQL Serve
database. How is this done? I have Microsoft Access XP.

I notice that the "Export" feature doesn't work unless you select
table. Does that mean that I cannot export the entire database in on
operation, but will need to export each table individually? What abou
the relationship between tables?

Also, I was told that Access XP has an "Export to SQL Server" feature
I didn't see that.

Thank you for your help
 
You can use the Enterprise manager that comes with sql server to import a
mdb file. It is quite good at doing the import.

It is not clear here if you are just trying to move some data to sql server,
or you place to move the data to the sql server, but keep ms-access for the
front end interface.

One should note that ms-access is not really a database, but only a tool
that connects to databases. ms-access as tool thus just allows you to create
a interface to a database engine. However, sql server comes with NO tools to
make the interface, or so called front end...
 
Back
Top