Com Error & Asp.net

[crosswire]

and this will make it work on any excl not jus excel 2003?????

No, the point is that xml or html is exported see CHM doc under export function

[Offroad]

CallAccounting\ Reports\Cost Calls

keroed1 you keep on using this so I don't think it is a type-o. Do you mean to put a space before Reports? I would tend to remove things like that, although it should work the same in all environments it probably wont. I doubt it is the problem, but I would suggest changing it anyway.

[keroed1]

oh ok cool, yeah @offroad i will do that.................................ques @offroad u know anything about writing a update comannd using oledb

[keroed1]

Dim conAccount As OleDbConnection
conAccount = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA Source=" & Locate_Database() & " ")

conAccount.Open()

Dim cmdSelectCount As OleDbCommand

cmdSelectCount = New OleDbCommand("UPDATE CallData SET Comment=@comment WHERE CallData.call_id=@cid", conAccount)

cmdSelectCount.Parameters.Add("@cid", Integer.Parse(Me.tbx_key.Text))
cmdSelectCount.Parameters.Add("@comment", "kenny") 'Me.txt_comment.Value)

cmdSelectCount.ExecuteNonQuery()

[Offroad]

	var MM_editCmd = Server.CreateObject('ADODB.Command');
	MM_editCmd.ActiveConnection = MM_CRMap_STRING;
	MM_editCmd.CommandText = "UPDATE Listings SET ";
	MM_editCmd.CommandText += "Contact='" + Encode(Request.Form("Contact")) + "', ";
	MM_editCmd.CommandText += "[Desc]='" + Encode(Request.Form("Comments"))+ "' ";
	MM_editCmd.CommandText += "WHERE ((AdId=" + String(Request.Form("AdId")) + ") AND (ListingId=" + String(Request.Form("ListingId")) + "))";
	MM_editCmd.Execute();
	MM_editCmd.ActiveConnection.Close();

here is a snippit of my code if that helps at all. Its JavaScript but it should help I would think.

I like to build everything into my CommandText. I find it cleaner. I dont use the @var ability. I don't even think JavaScript allows it. But setting the variables after they are used seem weird to me. I also feel it could make it harder to debug. But that doesn't mean it wouldn't work, it is just not something I find logical.

[keroed1]

Both machines environments should produce the xml format of the spreedsheet given that code. Did you mean that you got some form of binary file on your machine?

THIS IS WHAT I SEE
<?xml version="1.0"?>
<ss:Workbook xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:c="urn:schemas-microsoft-comffice:component:spreadsheet">
<x:ExcelWorkbook>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ActiveSheet>0</x:ActiveSheet>
</x:ExcelWorkbook>
<ss:Styles>
<ss:Style ss:ID="Default">
<ss:Alignment ss:Horizontal="Automatic" ss:Rotate="0.0" ss:Vertical="Bottom"
ss:ReadingOrder="Context"/>
<ss:Borders>
</ss:Borders>
<ss:Font ss:FontName="Arial" ss:Size="10" ss:Color="Automatic" ss:Bold="0"
ss:Italic="0" ss:Underline="None"/>
<ss:Interior ss:Color="Automatic" ss:Pattern="None"/>
<ss:NumberFormat ss:Format="General"/>
<ss:Protection ss:Protected="1"/>
</ss:Style>
<ss:Style ss:ID="wc0E54F9E0">
<ss:Alignment/>
<ss:Font ss:Color="#0000FF" ss:Bold="1"/>
<ss:Interior/>
</ss:Style>
<ss:Style ss:ID="wcC627F9E0">
<ss:Alignment/>
<ss:Font ss:Color="#0000FF" ss:Bold="1"/>
<ss:Interior/>
<ss:NumberFormat ss:Format="dd-MMM-yyyy"/>
</ss:Style>
<ss:Style ss:ID="wcCF87F9E0">
<ss:Alignment/>
<ss:Font ss:Color="#0000FF" ss:Bold="1"/>
<ss:Interior/>
<ss:NumberFormat ss:Format="hh:mm:ss AM/PM"/>
</ss:Style>
<ss:Style ss:ID="wc87E7F9E0">
<ss:Alignment/>
<ss:Font ss:Color="#0000FF" ss:Bold="1"/>
<ss:Interior/>
<ss:NumberFormat ss:Format="h:mm:ss"/>
</ss:Style>
<ss:Style ss:ID="wc0817F9E0">

[crosswire]

I figure that the same file above is produce on the Office2003machine and the Office2000Machine.

Try downloading the above file to the hard drive and then open it in Office2000 for the Office2000Machine.

I tried opening the fragment that (above) as an .xls file after fixing up the closed tags in ExcelXP and it did not seem to work.

The Export method will export to xml format (above) or html format. There is no binary. Ooops, my mistake.

[keroed1]

i tried opening the file in office 2000 but thats exactly what comes up in office 2000, first ask me about some delimeter i think it was conversion and i followe through the steps but it still came up jus like that

[keroed1]

or question crosswire wat do uthink is the best way for me to export a datset after it has been filled to excel???

[crosswire]

as XML, if u plan to keep the chnges that you made then use a diffgram.

likely, u should include the schema.