New Excel Import Tool
A client recently had a requirement to automatically import data from excel files into their database on a daily/weekly basis. Today we are pleased to annouce the release of a new Excel Import Tool which does exactly that.
The Excel Import Tool enables you to automatically import all data from an excel file into an MSSQL & Oracle database. The tool allows you to configure the folder, file name (begins with), tab name and of course the destination table name. The tool also imports the values from cell formulas and you also have the option to ignore the first row if it includes headers. The tool can also archive the excel file into a folder once it has been successfully imported into the database. You can schedule the application to run automatically by calling the executable in a batch file with a configuration file. You can run multiple instances of the .NET application if you need to import large numbers of files in parallel.
Please contact us if you are interested in automatically importing excel data into a database.