0
Excel offers the ability to connect to external data sources. I am told I can connect to a Sybase database to import some data into excel from a query.
How do I do this? I have the following:
- Query
- Server
- Port
- Database
- Username
- Password
I know this can be done with VBA also, but I'd prefer to do it with the interface so I can teach others.
Cheetah
Posted 2014-05-20T21:12:22.460
Reputation: 891
Where are you getting stuck? Take that query, server, etc info and apply it to the process: http://office.microsoft.com/en-us/excel-help/use-microsoft-query-to-retrieve-external-data-HA010099664.aspx (first result from googling: excel external database)
– Wutnaut – 2014-05-20T21:23:40.467@Wutnaut I don't know what goes in the "DataSource" and "initialCatalog" sections – Cheetah – 2014-05-20T21:49:05.843
"What is a data source? A data source is a stored set of information that allows Excel and Microsoft Query to connect to an external database. When you use Microsoft Query to set up a data source, you give the data source a name, and then supply the name and the location of the database or server, the type of database, and your logon and password information. The information also includes the name of an OBDC driver or a data source driver, which is a program that makes connections to a specific type of database." You set up the DataSource. – Wutnaut – 2014-05-20T21:52:13.380
I'm not sure about 'initialCatalog', my guess is they mean "root directory". Try leaving blank or "." – Wutnaut – 2014-05-20T21:53:06.430
Sorry, what I meant is I get to a screen which has a "DataSource" textbox on it. Clearly this needs to contain the server and port, but what is the format? – Cheetah – 2014-05-20T21:55:56.623