0

I'm starting to use data connections in Microsoft Excel to an Oracle SQL database using ODBC. I'm confused as to the intended method of using data connections.

It appears as through a data connection is linked to a query, so if my workbook has 100 queries then I need to make 100 data connections. Is this correct or can you use a single data connection to perform multiple queries?

Improve this question

1 Answer 1

Reset to default
1

If all the data is in one data source, you only need to make one connection. Multiple data sources would only be needed if the data you need is in separate databases.

Having a data connection allows you to query that source as much as you like. Keep in mind that performance will suffer the more queries you have refreshing from that source.

Use Microsoft Query to retrieve external data

Create, edit, and manage connections to external data

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .