|
|
Excel2MySQL 1.0 : Help File
WHAT Does it do ?
- convert first sheet of an excel file into a Mysql table.
- uses filename to create table .
- uses first line of the excel sheet to create sql columns.
- default datatype of each field will be varchar(255)
- however you may control field type. if first row of a column is name(vc:50) then data type of the column will be varchar(50).
- right now supported custom data types are VC = varchar, C = char, I = int, BI = bigint, SI = smallint, T = text, TT = tinytext, B = blob, TB = tinyblob. However these are not case sensitive.
- uses each following row (from 2 to N) to create inserts.
- does not actually perform the sql : please copy and paste to your favorite sql admin interface.
HOW TO INSTALL:
- Extract excel2mySQL.zip and upload to your webserver.
- Set full write permission to xls folder.
- Load your site in Browser.
Xls2Mysql get helps from :
|
|