Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import MS Access database into SQL Server 2005 Expand / Collapse
Author
Message
Posted Wednesday, May 23, 2007 9:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 15, 2013 7:37 AM
Points: 351, Visits: 152

Hello,

I have a database MS access: test.mdb.

Is it possible to attach to SQL SERVER 2005, or any other solution ?

 

Thank




Post #368324
Posted Thursday, May 24, 2007 2:17 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, September 15, 2014 8:25 AM
Points: 769, Visits: 251
Not sure what you are asking.  Do you want to be able to store the data in SQL Server and link from Access?  yes, you can do that.  Do you want to be able to link from SQL Server to Access?  Yes, you can do that, too with a Linked Server.

Aunt Kathi
Microsoft
(Former SQL Server MVP)
Post #368814
Posted Friday, May 25, 2007 12:44 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 15, 2013 7:37 AM
Points: 351, Visits: 152

I mean, to import the whole database to SQL server 2005 (structure and data).

Thank




Post #368907
Posted Friday, May 25, 2007 7:17 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, September 15, 2014 8:25 AM
Points: 769, Visits: 251
You can import tables using the import wizard in SQL or the upsize wizard in access. Access queries will import as tables.

Aunt Kathi
Microsoft
(Former SQL Server MVP)
Post #369004
Posted Friday, May 25, 2007 9:13 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, December 18, 2010 3:42 PM
Points: 103, Visits: 10,058
I have used http://www.microsoft.com/sql/solutions/migration/access/default.mspx for upgrading an MDB to a SQL 2005 database and an ADP.   It worked well for me.
Post #369068
Posted Friday, May 25, 2007 9:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 15, 2013 7:37 AM
Points: 351, Visits: 152

thank to everybody

 

 




Post #369091
Posted Friday, May 25, 2007 2:31 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 15, 2013 7:37 AM
Points: 351, Visits: 152

I run the tool and MS access DB was converted to SQL server DB.

 

Thank




Post #369187
Posted Friday, April 25, 2008 5:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 17, 2013 12:42 PM
Points: 4, Visits: 66
Where's the import wizard in SQL Server 2005?
Post #490986
Posted Monday, April 28, 2008 6:52 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
DEvenson (4/25/2008)
Where's the import wizard in SQL Server 2005?


Right-click on the database in SSMS object explorer, select TASKS --> IMPORT DATA ....

Post #491341
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse