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

We have 942 guests and no members online