Documentation
Connecting to Text databases
To connect to text databases, please choose folder where TXT, CSV or TSV files are stored. Each such file represents one table.
In such files, if first data row contains column names instead of actual data record, please check appropriate option. If this option is not checked, columns will be named automatically starting with F1.
For delimited text files, you can select separator which delimits individual data fields. All characters are valid except for ".
You can preview the first file in the folder to be able to quickly recognize its structure - click the 'Preview' button for the file to open the file. In the example below we see that there are no column names in the first row, and that fields are separated with commas.
If you want to output to Text files and select Text as a target, we will give you and additional option - you can opt to save in ANSI format (one byte per character) or in Unicode format (2 bytes per character), depending on your needs.
- Full Convert
- Buy now!
- Download free trial
- Features
- Screenshots
- Testimonials
- Version history
- Tutorials
- Video tutorials
- Online help
Introduction- Overview
- How to buy?
- Versions
- Quick start
- Interface
- Session wizard
- Convert
- Interface tour
- Interface overview
- Session wizard
- Overview
- Source database
- Target database
- Tables selection
- Table settings
- Summary
- Menu
- Toolbar
- Database structure tree
- Table data grid
- Options dialog
- Conversion summary
- Summary
- Error log
- SQL log
- Scheduler
- Welcome Dialog
- Connecting to databases
- Access
- DBF (dBase and FoxPro)
- Excel
- Interbase/Firebird
- Lotus 1-2-3
- MySQL
- ODBC
- Oracle
- Paradox
- SQL Server
- Text
- XML
- Actions
- Column editor
- Modify data
- Extract to new table
- Create referencing column
- Execute SQL statement
- Options
- General
- Conversion
- Transform
- SQL Server
- MySQL
- Oracle
- DBF (dBase or FoxPro)
- ODBC
- Text
- Interbase/Firebird
- Advanced
- Session settings
- Command line
- Session overrides
- History
- Version history
August 18, 2010
Full Convert 5.7 released
To see detailed version history of this application, click here.
We have used Full Convert Enterprise Software by Spectral Core for a number of data conversion projects, mainly from DBF/Paradox tables to both SQL Server and mySQL.
The software has greatly reduced the time and effort required to convert the data. When we came across a problem with the conversion of one DBF table to SQL Server, Spectral Core's support was fantastic: they responded almost immediately, took a copy of our problem data and within a day had identified a minor issue with Full Convert. They then issued an upgrade which has cured the problem.
Our investment of $299 in the software has already been recouped in the time saved on data conversion. I would recommend this product to anyone involved in data conversion and I would highly recommend the speedy service and professionalism of the Spectral Core support team.
