Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Trouble Shooting

Buy now

Download now

SQL*XL online help

 

SQL*XL: SQL*XL VBA API Help

SQL*XL API Visual Basic for Applications Help

SQL*XL
home
SQLXL      
  Database    
    Parameters  
  SQL    
    Statements  
      Statement
  Targets    
Target
  LITErr    

 

SQL*XL commands can be executed using VBA (Visual Basic for Applications) coding. This section of the help file explains the SQLXL syntax. Similarly to Excel VBA programming, the best way to start is to record a macro to see what code it generates.

Above is the SQL*XL object hierarchy. All code is embedded in the object SQLXL. If you type SQLXL. (don't forget the dot at the end) and you do not get a list of available properties and methods please add a reference to sqlxl.xla to your project. Refer to the Excel VBA help file how to achieve this.

SQL*XL ribbon in Excel