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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | MamathaPosting Yak  Master
 
 
                                        102 Posts | 
                                            
                                            |  Posted - 2005-01-11 : 23:17:16 
 |  
                                            | HiI have a SQL Server database table structure,that structure contains all the fields in the table with datatypes and their lengths.Now,using that structure i want to convert it as a MS-Access table.How can i do this?Is there any suggesstions for that,if you have please let me know.Mamatha |  |  
                                    | madhivananPremature Yak Congratulator
 
 
                                    22864 Posts | 
                                        
                                          |  Posted - 2005-01-13 : 00:55:03 
 |  
                                          | In the EnterPrise Manager goto that database right click choose export data. Then choose copy from as your SQL database and select Destination as MS Access and follow the stepsMadhivanan |  
                                          |  |  |  
                                |  |  |  |