Connecting Excel to SQL with VBA

Hello guys I was directed to this site as THE place to find information on how to write the connection string I need. I am still quite new at this coding stuff so any help would be appreciated.

Here is what I am trying to do:

I need to use VBA in Excel to create a connection to a SQL database that I will then query data from. I have used the macro recorder to create a macro for this and it works for me on my machine because I have the connection file it created but it does not work for anyone else.

I need this to be usable by anyone on the network I give the file to. I am building this using Excel 2013 64-bit however the end user is going to have Excel 2007 32-bit. The SQL server I am connecting to is SQL 2000.

Please let me know if you need more information.

Thanks for all the help.

1 answer

I highly recommend the following page: http://www.fontstuff.com/ebooks/free/fsadoconnectexcel.pdf

Also, if you do a web search for "VBA ADODB SQL Server" then you will find answers very quickly.