Hi
I need to read the data from sql server and convert it into xml ;
I configured MsAccess with Sqlserver and i tried exporting a table;I have 5 records in the table;
In the xml -only one column that too only for the first row the data is not embedeed within CDATA tag.For all the remaining 4 rows that column is within CDATA tag.How to resolve this.Thanks
I am not sure how this can go, but can you get the data from your SQL Server through your Ms Access database, if you so from access, you can convert the data to an XML file. You will need MS Access 2003 to achieve this, my Premium 2000 cannot do this, can only do this at work:
(1) In MS Access, build a form that'll look up data you have in a specific table
(2) Add buttons to Save the file on yur local system
(2) Fire up the form, Filter for specific data, then hit your Save button
Note: If you have your button wizard running when you build your form, you will have the option of having the code wirtten for you.
(4) Your are [promted to save in a file format type, choose XML, XSL, and XSD
(5) Your form will load three file where you choose and voilà...