|
Data Import and Export
Similar to the very popular tool phpMyAdmin SqlDBU offers table dump imports and exports (structure or structure + data). As an additional option SqlDBU supports data import from DBF (dBaseIII/IV und Clipper) and CSV files (exported by MS Excel).
When importing DBF files existing tables matching the DBF name will be overwritten, e.g. mytest.dbf overwrites an existing table with the name mytest. When importing CSV files existing tables matching the CSV file name will be appended.
If the table does not exist it will be created based on structure information contained in the first line of the appropriate CSV file.
Note: The CSV file needs to have the first line with field names in order to be successfully imported. If these structure information are missing the import results are unpredictable.
Back
|
