标题:如何把excel 表中的数据批量导入sql 2005数据库中
只看楼主
woxingx
Rank: 2
等 级:论坛游民
帖 子:46
专家分:68
注 册:2012-11-8
结帖率:100%
已结贴  问题点数:20 回复次数:6 
如何把excel 表中的数据批量导入sql 2005数据库中
求各位大神指点,如何把excel的数据批量导入SQL2005中数据库
最好是指明如何在SQL上操作  
小女子不胜感激
搜索更多相关主题的帖子: 不胜感激 excel 数据库 小女子 如何 
2013-10-09 23:12
303770957
Rank: 11Rank: 11Rank: 11Rank: 11
等 级:小飞侠
威 望:6
帖 子:838
专家分:2125
注 册:2005-9-10
得分:5 
用sqlserver2005的导出导入工具呀!

♂ 死后定当长眠,生前何须久睡。♀
2013-10-09 23:47
tlliqi
Rank: 19Rank: 19Rank: 19Rank: 19Rank: 19Rank: 19
等 级:贵宾
威 望:204
帖 子:15453
专家分:65956
注 册:2006-4-27
得分:15 
SQL2005中直接可以实现导入功能。操作过程如下:

第一步:进入 SQL 2005,

第二步:在 “对象资源管理器 ”中右键单击 “管理 ”,在弹出列表中单击 “导入数据 ”

第三步:在 “导入向导 ”对话框中单击 “下一步 ”,进入到 “选择数据源 ”对话框,在 “数据源 ”列表中选择 “Microsoft Excel ”,同时选择相应的 Excel 文档,完成后单击 “下一步 ”(一定要勾选该对话框中的 “首行包含列名称 ”,因此它是将 Excel文档中的列标题为数据库表中的列项标题)

第四步:指定目标数据库服务,依次单击 “下一步 ”。。。。至到 “完成 ”

第五步:重新打开 SQL 2005,进入到导入的数据库表,可以发现所导入的 Excel文档数据。


2013-10-10 07:29
woxingx
Rank: 2
等 级:论坛游民
帖 子:46
专家分:68
注 册:2012-11-8
得分:0 
回复 3楼 tlliqi
非常感谢 我
2013-10-10 13:15
dunzhuqujie
Rank: 1
等 级:新手上路
帖 子:8
专家分:0
注 册:2013-10-13
得分:0 
“数据源 ”列表中选择没有 “Microsoft Excel ”选项;
咋么设置
2013-10-28 23:19
dunzhuqujie
Rank: 1
等 级:新手上路
帖 子:8
专家分:0
注 册:2013-10-13
得分:0 
菜单右侧弹出层商品分类菜单如何讲access数据库里的菜单显示到相应的位置、好像用循环不知道到如何写:请高手们请教

菜单右侧弹出层的代码如下:
<div class="menuNav">
    <h2></h2>
    <div class="navlist" id="SNmenuNav" >
        <dl>
            <dt class="icon03" ><a href="http://www.服装内衣</a></dt>
            <dd class="menv03">
                <ul class="sideleft">
                    <li class="noline"> <b><a href="http://www. >CSS</a></b>
                        <div> <a href="#" >全部</a> <a href="http://www. >html基础</a> <a href="http://www. >css基础</a> <a href="#" >10001-20000元</a> <a href="#" >20001-30000元</a> <a href="#" >30000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="@" >3D电视</a></b>
                        <div> <a href="#" >全部</a> <a href="#" >3000元以下</a> <a href="#" >3000-10000元</a> <a href="#" >10001-20000元</a> <a href="#" >20001-30000元</a> <a href="#" >30000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >液晶电视</a></b>
                        <div> <a href="#" >全部</a> <a href="#" >3000元以下</a> <a href="#" >3000-10000元</a> <a href="#" >10001-20000元</a> <a href="#" >20001-30000元</a> <a href="#" >30000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >等离子电视</a></b>
                        <div> <a href="#" >全部</a> <a href="#" >3000元以下</a> <a href="#" >3000-10000元</a> <a href="#" >10001-20000元</a> <a href="#" >20001-30000元</a> <a href="#" >30000元以上</a> </div>
                        <span class="clear"></span> </li>
                         <li > <b><a href="#" >等离子电视</a></b>
                        <div> <a href="#" >全部</a> <a href="#" >3000元以下</a> <a href="#" >3000-10000元</a> <a href="#" >10001-20000元</a> <a href="#" >20001-30000元</a> <a href="#" >30000元以上</a> </div>
                        <span class="clear"></span> </li>
                         <li > <b><a href="#" >等离子电视</a></b>
                        <div> <a href="#" >全部</a> <a href="#" >3000元以下</a> <a href="#" >3000-10000元</a> <a href="#" >10001-20000元</a> <a href="#" >20001-30000元</a> <a href="#" >30000元以上</a> </div>
                        <span class="clear"></span> </li>
                </ul>
                <ul class="sideright">
                    <h3>品牌推荐</h3>
                    <li><a href="#" >索尼</a></li>
                    <li><a href="#" >三星</a></li>
                    <li><a href="#" >夏普</a></li>
                    <li><a href="#" >飞利浦</a></li>
                    <li><a href="#" >TCL</a></li>
                    <li><a href="#" >松下</a></li>
                    <li><a href="#" >LG</a></li>
                </ul>
            </dd>
        </dl>
               
        <dl>
            <dt class="icon04"><a href="#" >鞋包配饰</a></dt>
            <dd class="menv04">
                <ul class="sideleft">
                    <li class="noline"> <b><a href="#" >家用空调</a></b>
                        <div> <a href="#" >全部</a> <a href="" >2000元以下</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6001-8000元</a> <a href="" >8001-10000元</a> <a href="" >10000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >商用空调</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >2000元以下</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6001-8000元</a> <a href="" >8001-10000元</a> <a href="" >10000元以上</a> </div>
                        <span class="clear"></span> </li>
                </ul>
                <ul class="sideright">
                    <h3>品牌推荐</h3>
                    <li><a href="#" >格力</a></li>
                    <li><a href="#" >美的</a></li>
                    <li><a href="#" >三菱重工</a></li>
                </ul>
            </dd>
        </dl>
        <dl>
            <dt class="icon05"><a href="#" >运动户外</a></dt>
            <dd class="menv05">
                <ul class="sideleft">
                    <li class="noline"> <b><a href="#" >对开门冰箱</a> </b>
                        <div> <a href="#" >全部</a> <a href="#" >120-150升</a> <a href="#" >150-180升</a> <a href="#" >180-200升</a> <a href="#" >200-220升</a> <a href="#" >220升以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >2开门冰箱</a> </b>
                        <div> <a href="#" >全部</a> <a href="#" >120-150升</a> <a href="#" >150-180升</a> <a href="#" >180-200升</a> <a href="#" >200-220升</a> <a href="#" >220升以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >3开门冰箱</a> </b>
                        <div> <a href="#" >全部</a> <a href="#" >120-150升</a> <a href="#" >150-180升</a> <a href="#" >180-200升</a> <a href="#" >200-220升</a> <a href="#" >220升以上</a> </div>
                        <span class="clear"></span> </li>
                </ul>
                <ul class="sideright">
                    <h3>品牌推荐</h3>
                    <li><a href="#" >西门子</a></li>
                    <li><a href="#" >容声</a></li>
                    <li><a href="#" >新飞</a></li>
                    <li><a href="#" >美菱</a></li>
                    <li><a href="#" >LG</a></li>
                    <li><a href="#" >海信</a></li>
                </ul>
            </dd>
        </dl>
        <dl>
            <dt class="icon06"><a href="#" >手机数码</a></dt>
            <dd class="menv06">
                <ul class="sideleft">
                    <li class="noline"> <b><a href="#" >烘干机</a> </b>
                        <div> <a href="#" >全部</a> <a href="#" >4-6公斤</a> <a href="#" >6-8公斤</a> <a href="#" >8公斤以上</a> <a href="" >2000元以下</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >滚筒机</a> </b>
                        <div> <a href="#" >全部</a> <a href="#" >4-6公斤</a> <a href="#" >6-8公斤</a> <a href="#" >8公斤以上</a> <a href="" >2000元以下</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >波轮机</a> </b>
                        <div> <a href="#" >全部</a> <a href="#" >4-6公斤</a> <a href="#" >6-8公斤</a> <a href="#" >8公斤以上</a> <a href="" >2000元以下</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6000元以上</a> </div>
                        <span class="clear"></span> </li>
                </ul>
                <ul class="sideright">
                    <h3>品牌推荐</h3>
                    <li><a href="#" >博世</a></li>
                    <li><a href="#" >西门子</a></li>
                    <li><a href="#" >小天鹅</a></li>
                    <li><a href="#" >松下</a></li>
                    <li><a href="#" >东芝</a></li>
                    <li><a href="#" >荣事</a></li>
                    <li><a href="#" >小鸭</a></li>
                    <li><a href="#" >海尔</a></li>
                    <li><a href="#" >美的</a></li>
                </ul>
            </dd>
        </dl>
        <dl>
            <dt class="icon07"><a href="http://www. >母婴用品</a></dt>
            <dd class="menv07">
                <ul class="sideleft">
                    <li class="noline"> <b><a href="#" >索尼音响</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >2000元以下</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6001-8000元</a> <a href="" >8001-10000元</a> <a href="" >10000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >JVC音响</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >2000元以下</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6001-8000元</a> <a href="" >8001-10000元</a> <a href="" >10000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >JBL音响</a> </b>
                        <div> <a href="#" >全部</a> <a href="http://www. >div+css</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6001-8000元</a> <a href="" >8001-10000元</a> <a href="" >10000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >松下音响</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >2000元以下</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6001-8000元</a> <a href="" >8001-10000元</a> <a href="" >10000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >飞利浦音响</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >2000元以下</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6001-8000元</a> <a href="" >8001-10000元</a> <a href="" >10000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >LG音响</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >2000元以下</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6001-8000元</a> <a href="" >8001-10000元</a> <a href="" >10000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >先锋音响</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >2000元以下</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6001-8000元</a> <a href="" >8001-10000元</a> <a href="" >10000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="http://www. >CSS+DIV</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >2000元以下</a> <a href="" >2000-4000元</a> <a href="" >4001-6000元</a> <a href="" >6001-8000元</a> <a href="" >8001-10000元</a> <a href="" >10000元以上</a> </div>
                        <span class="clear"></span> </li>
                </ul>
                <ul class="sideright">
                    <h3>品牌推荐</h3>
                    <li><a href="#" >索尼</a></li>
                    <li><a href="#" >LG</a></li>
                    <li><a href="#" >三星</a></li>
                </ul>
            </dd>
        </dl>
        <dl>
            <dt class="icon08"><a href="#" >护肤彩妆</a></dt>
            <dd class="menv08">
                <ul class="sideleft">
                    <li class="noline"> <b><a href="#">剃须刀</a></b>
                        <div> <a href="#" >飞利浦剃须刀</a> <a href="#" >博朗剃须刀</a> <a href="#" >松下剃须刀</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#">吸尘器</a></b>
                        <div> <a href="#" >飞利浦吸尘器</a> <a href="#" >LG吸尘器</a> <a href="#" >三洋吸尘器</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#">电暖气</a></b>
                        <div> <a href="#" >先锋电暖气</a> <a href="#" >美的电暖气</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#">净化器</a></b>
                        <div> <a href="#" >飞利浦净化器</a> <a href="#" >夏普净化器</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#">电风扇</a></b>
                        <div> <a href="#" >美的电风扇</a> <a href="#" >先锋电风扇</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#">豆浆机</a></b>
                        <div> <a href="#" >九阳豆浆机</a> <a href="#" >美的豆浆机</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="http://www. css</a></b>
                        <div> <a href="#" >飞利浦电熨斗</a> <a href="#" >松下电熨斗</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#">加湿器</a></b>
                        <div> <a href="#" >亚都加湿器</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#">电动牙刷</a></b>
                        <div> <a href="#" >松下电动牙刷</a> <a href="#" >飞利浦电动牙刷</a> </div>
                        <span class="clear"></span> </li>
                </ul>
               
                <ul class="sideright">
                    <h3>品牌推荐</h3>
                    <li><a href="#" >飞利浦</a></li>
                    <li><a href="http://www. >DIV CSS</a></li>
                    <li><a href="#" >美的</a></li>
                    <li><a href="#" >九阳</a></li>
                    <li><a href="#" >先锋</a></li>
                    <li><a href="#" >夏普</a></li>
                    <li><a href="#" >三洋</a></li>
                    <li><a href="#" >LG</a></li>
                    <li><a href="#" >亚都</a></li>
                    <li><a href="#" >博朗</a></li>
                </ul>
            </dd>
        </dl>
        <dl>
            <dt class="icon09"><a href="#" >家具建材</a></dt>
            <dd class="menv09">
                <ul class="sideleft">
                    <li class="noline"> <b><a href="#" >蓝光播放器</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >2000元以下</a> <a href="" >2000-3000元</a> <a href="" >3001-4000元</a> <a href="" >4001-5000元</a> <a href="" >5000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="http://www. >DIV</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >500元以下</a> <a href="" >500-1000元</a> <a href="" >1001-2000元</a> <a href="" >2001-3000元</a> <a href="" >3000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >高清游戏机</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >500元以下</a> <a href="" >500-1000元</a> <a href="" >1001-2000元</a> <a href="" >2001-3000元</a> <a href="" >3000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="http://www. >CSS+DIV</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >100元以下</a> <a href="" >100-200元</a> <a href="" >201-300元</a> <a href="" >300元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >壁挂架</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >500元以下</a> <a href="" >500-1000元</a> <a href="" >1001-2000元</a> <a href="" >2000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >数字天线</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >500元以下</a> <a href="" >500-1000元</a> <a href="" >1001-2000元</a> <a href="" >2000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >电源插座</a> </b>
                        <div> <a href="#" >全部</a> <a href="" >100元以下</a> <a href="" >100-200元</a> <a href="" >201-300元</a> <a href="" >301-400元</a> <a href="" >401-500元</a> <a href="" >500元以上</a>
                        <a href="#" >全部</a> <a href="" >100元以下</a> <a href="" >100-200元</a> <a href="" >201-300元</a> <a href="" >301-400元</a> </div>
                        <span class="clear"></span> </li>
                </ul>
                <ul class="sideright">
                    <h3>品牌推荐</h3>
                    <li><a href="http://www. >DIV+CSS</a></li>
                    <li><a href="#" >松下</a></li>
                    <li><a href="http://www. >CSS</a></li>
                    <li><a href="#" >秋叶原</a></li>
                </ul>
            </dd>
        </dl>
         <dl>
            <dt class="icon10" ><a href="http://www.家纺居家</a></dt>
            <dd class="menv10">
                <ul class="sideleft">
                    <li class="noline"> <b><a href="http://www. >CSS</a></b>
                        <div> <a href="#" >全部</a> <a href="http://www. >html基础</a> <a href="http://www. >css基础</a> <a href="#" >10001-20000元</a> <a href="#" >20001-30000元</a> <a href="#" >30000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="@" >3D电视</a></b>
                        <div> <a href="#" >全部</a> <a href="#" >3000元以下</a> <a href="#" >3000-10000元</a> <a href="#" >10001-20000元</a> <a href="#" >20001-30000元</a> <a href="#" >30000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >液晶电视</a></b>
                        <div> <a href="#" >全部</a> <a href="#" >3000元以下</a> <a href="#" >3000-10000元</a> <a href="#" >10001-20000元</a> <a href="#" >20001-30000元</a> <a href="#" >30000元以上</a> </div>
                        <span class="clear"></span> </li>
                    <li > <b><a href="#" >等离子电视</a></b>
                        <div> <a href="#" >全部</a> <a href="#" >3000元以下</a> <a href="#" >3000-10000元</a> <a href="#" >10001-20000元</a> <a href="#" >20001-30000元</a> <a href="#" >30000元以上</a> </div>
                        <span class="clear"></span> </li>
                         <li > <b><a href="#" >等离子电视</a></b>
                        <div> <a href="#" >全部</a> <a href="#" >3000元以下</a> <a href="#" >3000-10000元</a> <a href="#" >10001-20000元</a> <a href="#" >20001-30000元</a> <a href="#" >30000元以上</a> </div>
                        <span class="clear"></span> </li>
                         <li > <b><a href="#" >等离子电视</a></b>
                        <div> <a href="#" >全部</a> <a href="#" >3000元以下</a> <a href="#" >3000-10000元</a> <a href="#" >10001-20000元</a> <a href="#" >20001-30000元</a> <a href="#" >30000元以上</a> </div>
                        <span class="clear"></span> </li>
                </ul>
                <ul class="sideright">
                    <h3>品牌推荐</h3>
                    <li><a href="#" >索尼</a></li>
                    <li><a href="#" >三星</a></li>
                    <li><a href="#" >夏普</a></li>
                    <li><a href="#" >飞利浦</a></li>
                    <li><a href="#" >TCL</a></li>
                    <li><a href="#" >松下</a></li>
                    <li><a href="#" >LG</a></li>
                </ul>
            </dd>
        </dl>
<script type="text/javascript">var _bdhmProtocol = (("https:" == document.location.protocol) ? " https://" : " http://");document.write(unescape("%3Cscript src='" + _bdhmProtocol + "hm.baidu.com/h.js%3F0dd64c3c686ec0e9dcf7911ab9189b2b' type='text/javascript'%3E%3C/script%3E"));</script><span style="display:none"><script src="http:// language="JavaScript"></script></span>


    </div>
</div>
2014-03-22 17:34
hyz00001
Rank: 3Rank: 3
等 级:论坛游侠
威 望:1
帖 子:168
专家分:137
注 册:2012-10-5
得分:0 
这个针对2000的数据库是否可行呢?
2014-04-24 08:52



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-421643-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.488591 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved