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 Dialogs SQL

Buy now

Download now

SQL*XL online help
 

SQL*XL: SQL dialog: SQL From option group

Statement optiongroup (SQL dialog)

SQL*XL
home


Specifies whether SQL*XL should take the SQL read from the worksheet as 1 statement or that each cell's contents should be regarded as a single statement.

You can e.g. use multiple cells to define a command. You may also use Excel formulae to make SQL. SQL*XL will only take the formula result.

Example:

If you have the following spreadsheet you may want to let SQL*XL treat all cells as one statement

 

A

B

C

D

1

select * from  

2

emp      

3

where empno= 4  

4

       

When you have the following spreadsheet you may want to let SQL*XL teat all cells as a statement:

 

A

B

C

D

1

select * from emp;      

2

select * from dept;      

3

select * from salgrade;      

4

       


See also:

SQL*XL ribbon in Excel