开发者

Changing Column name in Javascript

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜