Page Comparison

Use the import / export wizard to import MS Access tables to SQL Server.

Step-by-step guide

1. Open SSMS. (SQL Server Management Studio)
   
   
2. Right-click on Databases in the object explorer.
   Image Added
   
   
3. Select New Database
   Image Added
   
   
4. Create the LPad Database.
   Image Added
   
   
5. Right-click on the lpad LPad database in the Object Explorerobject explorer.
   Image Added
   
   
6. Select Tasks | Import Data... from the context menu.
   
   
   
   
   
7. Click Next...
   
   
   
   
   
8. Change the data source to Microsoft Access.
   
   
   
   
   
9. Browse for lpad.mdb. Click Next...
   
   
   
   
   
10. Click Next...
    
    
    
    
    
11. Click Next...
    
    
    
    
    
    1. Check all source tables in the form.  Also please make sure to look at the second screenshot to see which queries and tables need to be left unchecked. Click Next...
       
       
       
       
       
       
       
       
12. Check Run Immediately. Click Next..
    
    
    
    
    
13. Click Finish.
    
    
    
    
    
14. Close the wizard when the import is complete.
    
    

...