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.
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.