View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] snook@accelis.net is offline
external usenet poster
 
Posts: 1
Default Getting data from SQL

Hi,

I am trying to build a workbook with data from SQL. I need to prompt
the user for the SQL server, login and pwd (its in mixed mode)
everytime the workbook is opened.

I am new to this and I have explored the following options:

Building a login form and ADO recordsets

Using SQL.Request()

Our users are on various versions of Excel (all 2000+) so I want to
make sure it works for everyone.

thanks