-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sql queries
-
J
SQL password on Query
Hi All I am working on a workbook that get data from a Microsoft Query (The query gets info from a SQL server). When i run the Query a popup appears that requires a password Is there a way to Skip the password or a "macro" that can enter the password without "User" input??- JCHuysamer
- Thread
- microsoft query sql queries
- Replies: 0
- Forum: Excel Questions
-
K
Remove ODBC links to Sage SQL Server
I have a large spreadsheet (~100 tabs) that gets data from an SQL server using SQL queries. I am about to run a Year-End on Sage (for the first time) and am concerned that this will screw-up the data in the spreadsheet. I know that I can open each Tab in turn & unlink, or Copy/Paste...- krissz
- Thread
- excel2013 sql queries unlink
- Replies: 1
- Forum: Excel Questions
-
J
SQL Queries in Excel
I have the following seven Access queries that I need to convert into an Excel macro because there is not a lot of data in the two source tables and my coworkers are more comfortable working in Excel than Access. I am not sure of how to write the VBA around these SQL queries so that it will run...- jenae
- Thread
- convert access to excel excel vba macro sql queries sql query
- Replies: 0
- Forum: Excel Questions
