i have many utf16le files (table), i need a script for create/uptade sql table.
- utf16 files contain the columns in the first row (or second, must be able to define by file the "Number of lines to skip from the first line")
- Columns are separated by tabs
- Columns are not surrounded by quote
- sql table name can be custom or get the file name
- it should be possible to add a column at first like ID AutoIncrement or fixed value for all the file.
- must be able to overwrite a table or add data
the ideal would be to have a config file with all the parameters (file name, if more colone, overwrite or not,etc.)
i send you an example file by PM.