faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

12 of 21 people (57%) answered Yes
Recently 5 of 10 people (50%) answered Yes

Entry

Database:Microsoft SQL server:Import: How convert Microsoft Access database to Microsoft SQL server?

Mar 25th, 2005 10:37
Knud van Eeden,


----------------------------------------------------------------------
--- Knud van Eeden --- 14 December 2003 - 11:41 pm -------------------
Database:Microsoft SQL server:Import: How convert Microsoft Access 
database to Microsoft SQL server?
---
Steps: Overview:
 1. -Open the program 'Microsoft SQL server Enterprise manager'
     in your Microsoft SQL server directory
 2. -Select the database group in which you want to import
     in the left pane
     (so you have earlier created this database group) in the left pane
     e.g.
      'Microsoft SQL Servers'->'SQL Server Group'->'(local) (Windows 
NT)'->'Databases'
 3. -select from menu option 'Action'
     1. -select from list 'All tasks'
        1. -select from list 'Import Data...'
 4. -This will start the database conversion wizard
     1. -Click button 'Next'
     2. -Choose a 'Data Source'
         1. -Select 'Microsoft Access'
             from list 'Data Source'
             (you should choose the entry
              with the 'yellow key' icon,
              and thus not a driver)
         2. -Choose a file name
             1. Browse by clicking on '...'
                1. Select a file on your computer
                   or network
                   (thus with extension .mdb)
                   e.g.
                   H:\pdrive\radius\WinRadius.mdb
     3. -Click button 'Next'
         1. Possibly create a new database name in Microsoft SQL Server
            in which to store that Microsoft Access database
            1. -Select from list '<New>'
                in the field 'Database'
               1. Type a name
                   e.g.
                    mydatabasename
            2. -Click button 'OK'
     3. -Click button 'Next'
     4. -Click button 'Next'
     5. -Enable checkboxes of tables you want to convert
         1. -Possibly select the correct order if foreign keys
     6. -Click button 'Next'
     7. -Click button 'Next'
     8. -Click button 'Finish'
     9. -You should then see a message box showing:
         'Successfully copied ... tables from Microsoft Access to
          Microsoft SQL Server'
 5. -Possibly restart 'Microsoft SQL server Enterprise manager'
     to see the converted database
----------------------------------------------------------------------