Windows | Games | Mobile | Wallpapers


Relational eXcel 3.0

Relational eXcel is an application that reads in an Excel 2007 workbook.


Last Week downloads: 0
Total downloads: 221

User reviews

0 out of 5 based on 0 ratings for Relational eXcel 3.0

For Relational eXcel 3.0Publisher's description


Relational eXcel is a Office Tools software developed by Laszlo L. Lieszkovszky. After our trial and test, the software is proved to be official, secure and free. Here is the official description for Relational eXcel:

EditByBSEditor: Relational eXcel is an application that reads in an Excel 2007 workbook, optionally transforms the data, and either saves the results as SQL script files or loads the data directly into your Microsoft SQL Server database. 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 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.

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.
PerformanceRelational eXcel is built for performance. Provided you have
you can free download Relational eXcel 3.0 now.

For Relational eXcel 3.0Related Software


Please be aware that Brothersoft do not supply any crack, patches, serial numbers or keygen for Relational eXcel,and please consult directly with program authors for any problem with Relational eXcel.