0

I am not sure if what I want to do is possible...

I want to be able to connect to a database using the "Connection Wizard" in Microsoft Excel 2010, without copying an entire table into excel.

I need to run a select statement that is using several tables and enter this information into a spreadsheet on it's own. Is this even possible?

I have tried to use VBA to connect to the database and run my query but I am receiving this error : The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software.

I have added a reference to Microsoft Active X, but still not working. I have tried downloading drivers, with no success. I am able to connect to the database and run a query through Visual Studio, just not with Excel VBA.

Is what I want to do even possible?

Improve this question
3
  • 1
    Have a look at this: stackoverflow.com/questions/37875901/… It starts by pulling a random table from the SQL but then the connection is altered and an SQL-Select is executed instead to pull data from the SQL. Commented Mar 8, 2017 at 12:22
  • Are you not able to run a extract from the database, so instead of pulling from excel, push from the database. In this case it is easy enough to specify your query. Commented Mar 8, 2017 at 13:01
  • Possible duplicate of MS Excel - join external (SQL) data with local table (sheet) Commented Mar 10, 2017 at 13:17
Related questions
10
Can you connect to sql server from Excel?
31
Using Excel as front end to Access database (with VBA)
28
Accessing SQL Database in Excel-VBA
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.