ExcelBanter - View Single Post - Imprt data from SQL based on cell input

Thread: Imprt data from SQL based on cell input

View Single Post

#1

Report Post

Posted to microsoft.public.excel.programming

Newman Emanouel Newman Emanouel is offline

Newman Emanouel is offline

external usenet poster

Posts: 18

Default

Imprt data from SQL based on cell input

Thank You works

"Keith74" wrote:

Hi

I think you want something like

..Open "SELECT * FROM Authors where au-id= '" & sheet1.range("A1") &
"' - if au-id is a string

or

..Open "SELECT * FROM Authors where au-id= " & sheet1.range("A1") &
" - if au-id is a number

hth

Keith

Reply With Quote

Reply With Quote