Home > database >  Access 2010 database insert operations, field 86 wrong
Access 2010 database insert operations, field 86 wrong

Time:09-30

The statement is as follows:
"insert into tableBS(stockcode,source,报表日期,流动资产,货币资金,交易性金融资产,衍生金融资产,应收票据,应收账款,预付款项,应收利息,应收股利,其他应收款,买入返售金融资产,存货,划分为持有待售的资产,一年内到期的非流动资产,待摊费用,待处理流动资产损益,其他流动资产,流动资产合计,非流动资产,发放贷款及垫款,可供出售金融资产,持有至到期投资,长期应收款,长期股权投资,投资性房地产,固定资产净额,在建工程,工程物资,固定资产清理,生产性生物资产,公益性生物资产,油气资产,无形资产,开发支出,商誉,长期待摊费用,递延所得税资产,其他非流动资产,非流动资产合计,资产总计,流动负债,短期借款,交易性金融负债,应付票据,应付账款,预收款项,应付手续费及佣金,应付职工薪酬,应交税费,应付利息,应付股利,其他应付款,预提费用,一年内的递延收益,应付短期债券,一年内到期的非流动负债,其他流动负债,流动负债合计,非流动负债,长期借款,应付债券,长期应付款,长期应付职工薪酬,专项应付款,预计非流动负债,递延所得税负债,长期递延收益,其他非流动负债,非流动负债合计,负债合计,所有者权益,实收资本,资本公积,库存股,其他综合收益,专项储备,盈余公积,一般风险准备,未分配利润,归属于母公司股东权益合计,少数股东权益,所有者权益合计,负债和所有者权益总计) values(300464,1,3,0,2852.98,0,0,890.14,10181.61,2090.27,0,0,532.78,0,13389.84,0,0,0,0,4271.68,34209.31,0,0,0,0,0,299.09,0,34955.91,9103.05,50.05,0,0,0,0,4676.3,0,0,0,364.56,5071.58,54520.54,88729.85,0,12000,0,5155.06,6925.19,982.83,0,664.64,66.34,72.67,0,3297.11,0,0,0,0,277.34,29441.18,0,7142.2,0,0,0,0,0,0,0,599.77,7741.97,37183.16,0,20975.38,12703.93,2265.68,0,0,2582.59,0,17369.87,51366.07,180.62,51546.69,88729.85)";

The same way, tried five fields can be, but into so many fields is an error, really don't understand the reason, for a great god help analysis, thank you very much!

CodePudding user response:

Under his roof, is to use c # programming into the access database
  • Related