Thread: SQL - array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dave k dave k is offline
external usenet poster
 
Posts: 21
Default SQL - array

Is there a way to run a SQL Select on an array in VBA? If I Dim an array like
Dim x(100,100) as integer, can I perform a select statement on it?

Seems like you should be able to since it is like rows and columns from a
spreadsheet and is like a small database.

Thanks!
Dave