Access data base to SQL Server managment

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Access data base to SQL Server managment

Author

Topic

BoSCHoW
Starting Member

3 Posts

Posted - 2006-12-15 : 15:08:33

Hi all,

I have a data base made in MS access and i wanted to know if it is possible to import it into MS SQL server management. If it is possible could somebody write an example, from which i can learn how do i do that?

Thank you for your time and help
Best regards,
BoSCHoW.

bOSTJAN

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-12-15 : 15:33:17

You should start by learning about SQL Server, there's a lot you need to know that is different to Access.

For moving your database, look here
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0561.mspx?mfr=true
http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-from-access-to-sql-server.html

madhuotp
Yak Posting Veteran

78 Posts

Posted - 2006-12-16 : 00:07:55

Hi,

There are many ways to import access tables to SQL. simple way is to use IMPORT/Export Wizards in sql server.

Press right button of your mouse on the Database to which you want to import the access table

Select *Tasks* Option --> Select Import Option

then follow the instruction

Madhu

BoSCHoW
Starting Member

3 Posts

Posted - 2006-12-16 : 08:32:49

Thank you guys i really aprishiate your help.

bOSTJAN

BoSCHoW
Starting Member

3 Posts

Posted - 2006-12-22 : 03:57:51

Hi all,

I wanna thank for this valuable informations. I tried and it worked. But while searching how to migrate access database i found out than i can link it as well. Whats the difference between migration import/export a database to a server and link a database to a server? When is better to use a link method and when is better to use a migration method? And what are the advantages/disadvantages of the migration method? What are the advantages/disadvantages of the link method?

Thanks again for your time and help,
best regards
BoSCHoW.

bOSTJAN

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-22 : 04:40:04

It is better, performance wise, to UPGRADE to MS SQL (there is a upsize wizard available).

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources