Hi, I have an issue and I hope someone in this forum could help me.
I am trying to retrieve "XML Data" of a sequence . I am connected to SQL Server and I am able to query the Database.
However when I get the Result XML Data, I don't get the complete data. It seems that I am only getting the data till excel finds a semi colon.
Is there a way to get the complete data of the XML file from the server or is there a way to not just stop at a semi colon?
Note: I tried the same connection and query in MS Access 2007 and I am able to get the complete Data.
This is the SQL Query for your reference:
exec dbo.PROC_GetXMLStrOnSqlImage 'select ResultXML,Serialnumber,runnumber,Status,ResultXMLFileName from Table1 where serialnumber=''12345768390322''',''
I am trying to retrieve "XML Data" of a sequence . I am connected to SQL Server and I am able to query the Database.
However when I get the Result XML Data, I don't get the complete data. It seems that I am only getting the data till excel finds a semi colon.
Is there a way to get the complete data of the XML file from the server or is there a way to not just stop at a semi colon?
Note: I tried the same connection and query in MS Access 2007 and I am able to get the complete Data.
This is the SQL Query for your reference:
exec dbo.PROC_GetXMLStrOnSqlImage 'select ResultXML,Serialnumber,runnumber,Status,ResultXMLFileName from Table1 where serialnumber=''12345768390322''',''
