Index >> Business >> Office Suites & Tools >> Relational eXcel
Report SpywareRelational eXcel 3.4
Click to enlarge screenshot
Software Description:
Relational eXcel - a comprehensive data transformation and data loading tool
Relational eXcel is a comprehensive data transformation and data loading tool to help you work with your Excel, Access, CSV, or text based data and load it directly into your database server, or create SQL bulk insert script files.
Although Relational eXcel can be used to directly import a table from a workbook into a database, what sets it apart from the competition is that it can also transform that data on the fly and even add columns you didn't have in the original workbook. If you use Microsoft Excel, flat files, or Access as a front-end to some of the data stored in your database, but your schemas do not match exactly - for example, if the data in your Excel file is denormalized, whereas in your relational database it is normalized with foreign-key references and so on - then Relational eXcel is the perfect tool for the job.
Traditionally, when data needs to be read into a database but the database schemas do not specifically match that of your input data, a two-step process is used. Data is first read into temporary tables in the database, and then transformed using custom SQL script files. Writing these script files is a resource-intensive and error-prone operation. Relational eXcel solves this problem by transforming the input eXcel data on the fly before writing it to the database, thus eliminating the need for intermediate tables and custom SQL transformation scripts.
Relational eXcel is a comprehensive data transformation and data loading tool to help you work with your Excel, Access, CSV, or text based data and load it directly into your database server, or create SQL bulk insert script files.
Although Relational eXcel can be used to directly import a table from a workbook into a database, what sets it apart from the competition is that it can also transform that data on the fly and even add columns you didn't have in the original workbook. If you use Microsoft Excel, flat files, or Access as a front-end to some of the data stored in your database, but your schemas do not match exactly - for example, if the data in your Excel file is denormalized, whereas in your relational database it is normalized with foreign-key references and so on - then Relational eXcel is the perfect tool for the job.
Traditionally, when data needs to be read into a database but the database schemas do not specifically match that of your input data, a two-step process is used. Data is first read into temporary tables in the database, and then transformed using custom SQL script files. Writing these script files is a resource-intensive and error-prone operation. Relational eXcel solves this problem by transforming the input eXcel data on the fly before writing it to the database, thus eliminating the need for intermediate tables and custom SQL transformation scripts.
Feature List:
- Specifically define where the data is located in your workbooks: define the worksheet, the header row, the start and, optionally, the end row
- Only read in certain rows using trigger columns or require all fields to be filled in a row for that row to be read in
- Only read in parts of the data in a cell using regular expressions. For example, if your cells contain the text 'Mr. Neil Armstrong (age: 53)', then you could read the title, 'Mr', into one column in your database, the first name into another, the last name into a third, and the age into a fourth
- Generate ID columns with auto-incremented values or GUID-s generated by the application
- Create foreign-key columns that reference data in other tables in your worksheet
- Map certain values to other values. For example, consider a column that can contain the values 'Yes', 'True', 'Ok', 'No', 'False'. You could create a map to read cast these values to the appropriate bit value
100% Clean:
Relational eXcel 3.4 is 100% cleanThis download (RelationalExcelSetup_v3p4.zip) was tested thoroughly and was found 100% clean. Click "Report Spyware" link on the top if you found this software contains any form of malware, including but not limited to: spyware, viruses, trojans and backdoors.
Related Software:
- ExcelEverywhere for HTML 3.4.0 - Create WEB form that looks and functions the same as your MS Excel spreadsheet
- ONLYOFFICE Desktop Editor for Mac 4.1.1 - Open source office suite for working with text, spreadsheets and presentations.
- Grab Text 13.5 - Live text recognizer, capable of converting virtually anything to editable text!
- Amazing Visio for Microsoft Visio 4.0.2 - Add power to your Visio drawings with this tool set.
- novaPDF Lite 7.6.381 - novaPDF Lite allows you to easily create PDF files from any printable document.
- A-PDF Page Cut 5.1 - Break PDF pages to more pieces.
- ArtixMedia Menu Studio [Christmas Ed.] 3.71 - Create a gift multimedia CD-card to go with your presentations!
- Adds for Outlook 2.4 - Make an Alarm Clock and MP3 player from your Outlook!
- artiw outlook converter 4.5 - converts outlook/outlook express mail,contacts to pdf,chm,html,rtf,txt,xml etc
- Total Doc Converter 3.2 - Convert Doc to PDF, HTML, XLS, Image and Text Fast
top 10 most downloaded
recommended software
-
- A VIP Organizer
- VIP Organizer is a time and task management software which uses To Do List method to help you get through more work spending less time. It increases y...
-
- Salon Calendar
- Salon Calendar is a software tool designed specially for hair salons, beauty, manicure or aesthetic shops, tanning salons, fitness studios, wedding sa...
