Thread: Imprt data from SQL based on cell input
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Keith74 Keith74 is offline
external usenet poster
  
Posts: 120
Default Imprt data from SQL based on cell input
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 QuoteReply With Quote