Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
SQL Excel (Read 7200 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
SQL Excel
29.07.08 at 21:37:08
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.
See also:
SQL in Excel
Back to top
« Last Edit: 03.08.08 at 19:08:26 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1