I need a freeware software to convert from Excel file to the popular db formats (SQL server is the most important to me at the moment). Visual studio and it's sql server, came with a tool named DTSWizard ( Import and Export Data (32-bit) ), which is lacking the following feature I need:
1) If the row has an invalid value, it should skip it, write it to a log, and continue exporting the other rows.
The dts lacks the proper log mechanism, and every option I tried to make it write the rest of the rows on error have gone down the drain...
Does someone knows of such a program, or I shall write it myself?
Thank you!
1) If the row has an invalid value, it should skip it, write it to a log, and continue exporting the other rows.
The dts lacks the proper log mechanism, and every option I tried to make it write the rest of the rows on error have gone down the drain...
Does someone knows of such a program, or I shall write it myself?
Thank you!