|
|
|
| Downloads: 667 |
 Tell us about an update
|
 |
|
User Rating:
Rated by: |
NOT RATED
0 user(s) |
|
|
|
Relational eXcel description
|
Transform your Excel data and import it to SQL Server
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.
Get Relational eXcel and take it for a test drive to see what it's really capable of! Here are some key features of "Relational eXcel":
· 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.
Requirements:
· Microsoft .Net Framework 3.5 SP1
Limitations:
· Trial version runs the same as the full version for five days, after which time it runs in "nag-mode." In this mode all of the functionality is still present, but the user is presented with nag screens every so often.
|
|
Find us on Google+
