从excel导入到数据库 [英] import from excel to database
问题描述
我有一个excel文件,如下所示:
name(格式类型:一般)transaction_code(格式类型:一般)
======== ================================================== ========
xxx 99
ccc直接学分
sss 99
iii 99
当我只是将此文件保存到事务代码列的数据库时,第二行保存为null。但是当我将列transaction_type的格式类型更改为TEXT然后问题dsnt发生。所以如何将其保存到数据库格式类型:general?
数据库表是:
name varchar(50),
transaction_code varchar(50)
i have an excel file like as follows :
name(format type:general) transaction_code(format type:general)
==================================================================
xxx 99
ccc Direct Credit
sss 99
iii 99
when i am just saving this file to database for transaction code column the second row is saving as null.but when i change the format type of excel for the column transaction_type to TEXT then the problem dsnt occur.so how can i save it to database with the format type:general?
the database table is :
name varchar(50),
transaction_code varchar(50)
推荐答案
做一些google搜索...
Do one thing make some googling...
很棒解决方案.. * u **** @ madhubsu @gmail.com
Great Solution.. *u**** @madhubsu@gmail.com
这篇关于从excel导入到数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!