Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Dave Gruska: "Your software has easily saved me about 20+ hours (over SQL SSIS import) on a major project I have due this week".
Alex Freeze: "Good job! As always, MS SQL Data Wizard is at the front of my list with regards to when we advise a simple and powerful Microsoft SQL data manager".

More

Add your opinion

MS SQL Data Wizard online Help

Prev Return to chapter overview Next

Customizing target columns properties

Set the options of output files. The Objects tab allows you to edit names of result files (tables in case of exporting to MS Access) and their headers and footers. By default, the names of output files are set according to the tables/views names and queries titles. To change a file name, select the corresponding item at the Objects tab, press F2 and enter the new name.

 

To specify the result file's header and footer, double click the corresponding button and complete fields of the Header and Footer window.

 

To exclude a column from the exported data:

Select the object for which you want to exclude the column;
Clear the checkbox beside the column.

 

To rename a target file column, double click the corresponding caption or select the caption and use F2, and edit it manually.

 



Prev Return to chapter overview Next