<< Click to Display Table of Contents >>
Text export by AbsoluteSQL is always followed by a descriptive schema file specifying the data types and field sizes to be specified when reimporting the exported text files.
The schema file itself is a semicolon delimited text file named as the exported data file and with the .sch extension and of the structure:
as for example:
Though the field types SHORTINT, BYTE and EXTENDED in the schema file are tagged as SMALLINT, WORD and FLOAT, the original data types SHORTINT, BYTE and EXTENDED will still be accepted and used from the schema file, which thus may be edited to comply this if desired. However, the wider 16-bit data types SMALLINT and WORD are often preferred even if not strictly needed.
Schema files per se is not a standard, however the structure is often easily read, and either used by reading the contents for manual use or easily modifying the Schema file to comply with automated data structuring by the importing application.
Please see also menu File \ Import \ From Delimited Text File.
Please see also menu Export \ Grid Contents to CSV ...