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 |
|
flash99
Starting Member
3 Posts |
 Posted - 2003-04-04 : 04:55:58
|
| 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! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-04-04 : 07:15:23
|
| You don't need XML at all, and it's really a waste of time to bother with it for this application. Simply link the SQL Server tables in the Access database. There's a table linking wizard that does this for you in about 7 mouse clicks. Alternately, you can use DTS, Import/Export Wizard in SQL Server to export the data to an Access DB. That's also about 6-7 mouse clicks. Neither of these use XML because a) it's not needed, and b) it would only slow down and complicate things. |
 |
|
|
flash99
Starting Member
3 Posts |
Posted - 2003-04-04 : 09:08:51
|
| I am aware that it is possible to link the server with MSACCESS but I need XML as I will be using it for another application. Basically, I am designing an application which should be able to import and export to and from the sql server in order to use with different database software packages which support XML. Here XML will be used as the common format so that all applications that support XML can use it.If you look at MS ACCESS XP you will notice a facility which will alow you to export and import databases in XML format. The problem is I need to get the XML format from the MS SQL server the same as the one produced from the MS ACCESS package. I will probably need to use some sort of schema or view in order to acheive this, and I was wondering if any one could give me some directions in who to tackle this problem!!!Thanks! |
|
|
|
|
|
|
Import/Export(XML) MSSQL from/to Microsoft Access