那位老师会在用友中批量增加项目?

youjiashen

<p>下表是我从<font face="黑体">用友</font>中导出的项目表,由于公司销售都是<font color="#f70968">项目核算</font>,我是</p><p>卖车的,公司把每台车作为一个项目,应为每台车会相应的发生与之相关的费用,</p><p>这样好在月末考核每台车的毛利.&nbsp;每月业务量较大,没卖台新车就要增加一个项目,</p><p>销售高峰期要增加上千条项目,手工增加项目很累,请问那位知道能否从excel或access中导入增加项目.</p><p><table cellspacing="0" cellpadding="0" width="308" border="0" style="WIDTH: 231pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="51" style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865;"></col><col></col><col span="2" width="64" style="WIDTH: 48pt;"></col><col></col><col width="78" style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852;"></col><col></col><col width="51" style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865;"></col><col></col></colgroup><tbody><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl24" width="51" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 38pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">车号</font></td><td class="xl24" width="64" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">项目编号</font></td><td class="xl24" width="64" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">是否结算</font></td><td class="xl24" width="78" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">所属分类码</font></td><td class="xl24" width="51" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 38pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">合同号</font></td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl24" align="right" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">d225</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">001</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">　</font></td><td class="xl24" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">22</font></td><td class="xl24" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">55588</font></td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl24" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">　</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">　</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">　</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">　</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">　</font></td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl24" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">　</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">　</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">　</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">　</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">　</font></td></tr></tbody></table></p>

[此贴子已经被作者于2008-2-26 14:52:40编辑过]