Board index MS SQL Server

Import/Export(XML) MSSQL from/to Microsoft Access

Import/Export(XML) MSSQL from/to Microsoft Access

Post by flash9 » Sat, 05 Apr 2003 23:56:14



Hi, I would really appreciate it if someone could help me out here....

I have set-up a Microsoft SQL server 2000 database and I would like to
accomplish two things:
1. Import the Microsoft SQL server 2000 database in XML format so that I
   can use it with Microsoft Access XP.

2. The second thing is the same thing but the other way round (EXPORT).

I am aware of the different ways to query the database, and I have tried
a variety of methods, all of which results in producing XML, but cannot
be imported or exported with MS ACCESS.

The problem that is puzzeling me is how can I specify a query so that
the result is a valid XML document according to the MS ACCESS schema.

Thanks for any help in advance!

--
Posted via http://dbforums.com

 
 
 
Top

1. import/export MSSQL 6.5 and MSSQL 7.0

Hallo!

How can I export tables from Server SQL 7.0 into file and than import it
from file into Server SQL 6.5?
MSSQL 7.0 has import/export options but I can't find it in MSSQL 6.5. Thank
you for any sugestions.

Slawek

2. Serial line communication under AP Basic.

3. Access to to a productively MSSQL-Database with Microsoft Access

4. How to get rid of overflow pages in an ISAM table?

5. Import/Export XML Data

6. Oracle Instructors (Contract or Full-Time)

7. xml schema import and export tool ?

8. Maintaining state

9. Export/Import xml to SQL Server

10. Database bulk import / export using XML

11. Import/Export XML

12. xml schema import and export tool ?


All times are UTC
Board index