Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe
Home SQL*XL software

SQL Excel

The SQL Excel combination is a powerful one. SQL (Simple Query Language) is a language to interact with databases. Excel is a powerful spreadsheet application developed by Microsoft. The SQL*XL software combines SQL and Excel to make working with databases as easy as working with a spreadsheet.

Using SQL, large amounts of data in tables can be combined quickly and easily. SQL is not limited to data retrieval and can also be used to define and manipulate data and database objects. Further there exist programming language versions of SQL. In Oracle databases PL/SQL is used and in Microsoft SQL the T-SQL language can be used to make SQL programs.

Spreadsheets are used for data storage and analysis. Excel is the most important spreadsheet program in use today. Data can be combined with functions to be used for sophisticated analysis. In addition Excel offers basic graphing facilities as well as programming functions in the VBA macro language.

The SQL Excel combination implemented in the SQL*XL software enables the easy use of SQL in the Excel software. It adds database capabilities to Excel. SQL*XL is fully integrated with Excel. It adds a user interface for databases, new spreadsheet functions and it can be used through the VBA macro language as well.