Here is a small but useful tip:

you can now generate table creation script by simply clicking on the data

GenerateTableCreatingScript1

GenerateTableCreatingScript2

And here is the SQL script:

create table TableName (
[COMPANY NAME] CHAR(29),
[YEAR] CHAR(10),
[MONTHID] CHAR(9),
[PRODUCT ID] CHAR(12),
[AMOUNT] CHAR(12))

It is not ideal but it is a very good start

This update applies to both Visual Importer ETL and Advanced ETL Processor

Direct link, no registration required.
 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies