sql excell connection

Hi Community - is there anyway i can use the following code to connect to a MS Access DB stored on sharepoint instead of my local machine or a shared drive? I ran into some issues with permissions, and found that this DB would need to be stored on sharepoint- any guidance? Public Sub...

Hi is there a way to paste statements written in TOAD into Excel? save re-writing them cheers Dan

Hoping someone could shed some light on this issue for me - we have a retail management system using SQL and we use Access to run queries. We now use Power Pivot and pull the SQL statements into Excel. But when we use 64bit Office and ODBC, the SQL statements don't run. We have tried it on many...

Dear Expert, I am using below code to uploade data in SQL table, and it is working fine, i want to add one condition in this code, which is before uploade data in SQL Table it will check whether customer id already exist or not in SQL Table (Customers), if customer id is already there in SQL...

Hi Everyone This is the first time I am using this forum to ask a question about something I have spent a long time trying to do with not much luck. Essentially all I want to do is create a procedure/function in Excel such as =SQLdata(3), where 3 could be customer ID and then the function...