How to convert CSV into Database Table?
来源:互联网 发布:2018初级会计职称软件 编辑:程序博客网 时间:2024/06/04 18:39
CSV file:
COL1;COL2;COL31;2.1;a2;2.2;b3;2.3;c
the first line will be the column names, the rest of the data will be the content.
1. recognize data type
2. get table columns
3. create "create table" sql
4. execute it
5.create "Insert" sql, use prepareStatement. Therefore, setXXX should be adjusted by data type.
6. execute them all
- How to convert CSV into Database Table?
- SQLite Tutorial 5 : How to Import CSV or Excel file into SQLite database
- How to convert smartform output into pdf?
- How to convert Java String into byte[]?
- How to Create/Drop Database, Table
- how to convert OEL5 5 installation CDs into 1 DVD.
- How to convert a list of tensors into a tensor
- How to Log into H2 Database Console in Grails 2
- Convert datatab to csv
- How to Convert a 32-bit Database to 64-bit Database on Linux (remove olap)
- How to Convert a 32bit Database to 64bit Database on Linux
- Ruby CSV - An example of how to split CSV row data into fields
- How to: Generate XML file from database table
- MySQL how to show table in a database
- SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
- Insight into DOMDocument - how to convert data from XML to array in PHP
- table to csv
- How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure
- 日薄西山的下载工具
- How to get the tables of one schema?
- Windows Phone 十万个为什么--- 04 Q&A about new feature
- ora-12541:tns:无监听程序
- 自组装集群机器人国内研究现状
- How to convert CSV into Database Table?
- MVC&MonoRail 从webform到模板引擎
- 【正则表达式匹配】工具
- 使用自动生成java文件和自动编译的静态代理模式
- 剖析Linux系统启动过程
- 网络编程基础(1)—概述
- 简单模拟操作系统中的文件操作(2)
- InstallShield自定义安装界面
- 表单对齐,送给新手~