Many times companies get data from branch offices or from customers or vendors in csv or delimited or in database format different from the database which the company is using. To load the data into their database. programmers have to write long programs or use native data loading tools which do not provide much simplicity. In this way lot of man hours are wasted. To overcome this problem one can go for data converting tools. There are many tools available in the market, some are so highly priced that small or medium companies cannot even think of purchasing it. And, some are too cheap but do not meet desired objective. And of course some are reasonably priced one of them is Data Loader.
Data Loader is a powerful yet simple tool to import and export Data between many common formats. Current Data Loader Ver. 3.0 supports MS-SQL Server, MySQL, Oracle, MS Access, FoxPro, DBFs and 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 2003, Win 2000, XP, Win ME,Win98 &Win95
Now convert multiple delimited or csv textfiles into tables in one go. Change destination table names and column 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.
Data Loader is a simple yet powerful tool to import and export Data between many common formats. Current Data Loader Ver. 3.0 supports MS-SQL Server, MySQL, Oracle, MS Access, FoxPro, DBFs, 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 2003, Win 2000, XP, Win ME,Win98 &Win95
Now You can load from multiple textfiles 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.
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
