数据库表Excel 转Insert sql 语句
内容概要:
本Excel工具支持将Excel的数据,一键转换成insert的sql语句,并且在本地当前目录下生成sql文件
适用人群:
后端开发,运维
使用目标场景:
- 有一些数据,需要手动补录到某个表;
- 数据量很大,需要造数导入库
转换效果:
点击生成按钮,就能生成insert的sql文件,很方便
这就是用VBA实现的,支持动态识别 表字段column个数,行数,表名(就是sheet名)
INSERT INTO order_log
(id,order_id,user_id,amount,pay_datetime,channel_id,column06,column07,column08,column09,column10,column11,column12) VALUES
('10001','S00000010001','1594307','10000.1','2023-02-26','22:13:00','hello','','','','','',''),
('10002','S00000010002','5577531','12','2023-02-27','23:13:00','world','','','d','','',''),
('10003','S00000010003','9340805','2345','2023-02-28','00:13:00','nihao1','','asw','','','',''),
('10004','S00000010004','9367644','675','2023-03-01','01:13:00','alouha','','','','d','','ddd'),
('10005','S00000010005','7927008','23.23','2023-03-02','02:13:00','hhh','','','','','',''),
('10006','S00000010006','3327207','123','2023-03-03','03:13:00','hehe','','','','','',''),
('10007','S00000010007','2720718','34','2023-03-04','04:13:00','enenene','','','','','d',''),
('10008','S00000010008','2079841','123','2023-03-05','05:13:00','bye','','wde','','','','');
在下码脚本不易,如果有帮助的话
请作者(本人)喝杯咖啡吧,感谢支持:D ~
好人一生代码bug少
(帮忙介绍对象也行啊,来啊)
资源路径:
https://download.csdn.net/download/weixin_43891945/87503116
评论区也可以滴滴我 😄
北京转暖啦 ✨