Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connecting Excel 2007 to MySQL db?
Hi,
I would like to set up a complete new report in Excel which needs to get data from a MySQL database. I have Excel sheets where the connection works (the ODBC connector should work). But I have problems getting the connector to work in the new sheet. In Excel I choose Data -- From Other Sources -- From SQL Server. The 'Data Connection Wizard' appears. Next I should enter the 'Server name' and username and password that should be used. When I press Next this results in the following error message: [DBNETLIB]ConnectionOpen(Connect()).]The SQL-server does not exist or access to the server is refused What do I need to perform to get the connection working? Abel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connecting two series in a scatter chart - Excel 2007 | Charts and Charting in Excel | |||
connecting to MYSQL | New Users to Excel | |||
Best way to export from Excel to MySQL? | Excel Discussion (Misc queries) | |||
Using Excel for MySQL database import | Excel Discussion (Misc queries) | |||
MySQL and excel | Excel Discussion (Misc queries) |