开发者

Changing Column name in Javascript

开发者 https://www.devze.com 2023-04-12 01:56 出处:网络
adoConn.Open(\"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\\\;Extended Prop开发者_运维问答erties=\'text;HDR=Yes;FMT=Delimited\';\");
adoConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\;Extended Prop开发者_运维问答erties='text;    HDR=Yes;FMT=Delimited';");
adoRS.Open("Select * From [Data.csv]",adoConn,1,3);
for(var i=0; i<22; i++)
{
adoRS.Fields(i).Name=i;
}

i wnat to change column names but when i try this it gives error "Wroung number of argumentsor invalid Property Assignment.what is problem in my code.


the code to update column name is.

alter table tablename change oldname newname varchar (10);

Maybe you can replace the "select * ..." to the above code.

0

精彩评论

暂无评论...
验证码 换一张
取 消