SQL Server 2000 to Access ?
-
Hi i have a db on sqlserver 2000; How i can export tables and relations to a access db ? I need it cause access has db documentor; Thanks;
- There are lots of good documentation tools for sql. Better yet, try the metadata server in sql. 2) I suppose you could just link the access table to sql server.
-
Hi i have a db on sqlserver 2000; How i can export tables and relations to a access db ? I need it cause access has db documentor; Thanks;
Hi, You can do it by following the below steps: 1. Create a System DSN, giving the connectivity to the SQL Server database, which u want to import. 2. Create a new Acesss Databe(.mdb) 3. Goto files,select Get External Data -> Import. 4. Now from the file types, select the ODBC databases and locate the dsn whihc u have created. 5. Choose the tables which u want to import and click Ok. This will import all the selected SQl tables to your Acess databse. Indus_v:)
-
Hi, You can do it by following the below steps: 1. Create a System DSN, giving the connectivity to the SQL Server database, which u want to import. 2. Create a new Acesss Databe(.mdb) 3. Goto files,select Get External Data -> Import. 4. Now from the file types, select the ODBC databases and locate the dsn whihc u have created. 5. Choose the tables which u want to import and click Ok. This will import all the selected SQl tables to your Acess databse. Indus_v:)