Data Loader is a simple yet powerful tool to import and export Data between many common formats. Current Data Loader Ver. 4.0 supports MS-SQL Server, MySQL, Oracle, MS Access, FoxPro, DBF's, Excel, CSV & Delimited or Flat Files. You can use Data Loader to transfer data from one database format to another database format. While transferring you can filter columns and specify WHERE conditions.
It supports Long , Picture Data types. In a jiffy you can copy data without any coding.
Supported O/s:Win 7, Vista, Win 2003, Win 2000, XP, Win ME,Win98 &Win95
Data Loader Ver. 4.1 can also import Constraints like Primary keys, Unique Keys and Foreign Keys. Bulk Insert support is also added for MS SQL Server. Bulk Insert will load data several times faster than conventional insert statements.
Data Loader Ver. 4.0 can Synchronize databases by using UPDATE and INSERT feature. Data Loader will Update or Insert rows depending upon whether an existing row exist in the target table.
Now You can load from multiple CSV / Delimited Text files and change destination table names.
You can also Save and Schedule Sessions and Data Loader Scheduler will automatically executes sessions at your specified date and time.
Repository is introduced in Ver. 2.0. Now you can manage all your Sessions very easily.
Folder polling introduced in Ver. 3.0
Data Loader will watch for files in a folder at specified intervals and then load the data from filenames matching specified pattern into tables automatically