Copying tables from access to sql server express

I am trying to export a databse from access into sql server express. The access database is on a network and the sql server express is on my local machine.

Could someone give me setp by step instructions please as to how to export the data from the tables into my sql server express.

Thank you very much for your time

Access includes a wizard called the Upsize Wizard that can help you do this. Depending on which version of Access you have, it may be on different menus, but last time I saw it it was under Tools | Database Utilities.

You may have to install the Upsize Wizard if you don't already have the Advanced Wizards installed. Search the Access help file for information about using this tool.

Mike

Copying table

How we can Copy a table(with data) from one databse into another database at the same server

Quote:

Originally Posted by sajithamol

How we can Copy a table(with data) from one databse into another database at the same server

Hi,
you can copy the data by going to enterprise manager and right click on the table .go to tasks. then select import data. then follow the steps.|||

Quote:

Originally Posted by sajithamol

How we can Copy a table(with data) from one databse into another database at the same server

If you want to do that using queryanalyzer

1.Run the following query in Master database
select * into ToDatabase.dbo.Employee from FromDataBase.dbo.Employee

copying my database to another offsite computer

My need: I want to copy my databse (the file itself) in a mem card so that I can use it in another comuter offsite.
How do I do that. it s like a back up I think, except that I ll need to import the DB in another computer at home.
When I try using Backup the DB of Entreprise Manager, I get violation error, can t copy the file being used or something like that. Am I doing it the right way or is there another better way to do this.

Thanks

One way you can do this:

First you detach your database from EM , and find where your database's data file is, by default installation, the database file is in this folder: C:\Program Files\Microsoft SQL Server\MSSQL\Data.(attach the database after you copy it)

Then, copy the .mdf file of your database to your memory card.

From another computer, you can simply attach it through EM. Good to go.

|||thank u