Excel connection to a database

I’m trying to connect to an online database from Excel and the code below works fine on one PC (which runs Excel 2003) but its not working on the one I have running Excel 2007

The code below works on Excel 2003 so can you convert to Excel 2007 please

Dim oConn As [url removed, login to view]

Sub ConnectDB()

Set oConn = New [url removed, login to view]

[url removed, login to view] "DRIVER={MySQL ODBC 5.1 Driver};" & _

"SERVER=[url removed, login to view]" & _

"DATABASE=mydatabase;" & _

"USER=myusername;" & _

"PASSWORD=mypassword;" & _


End Sub

Færdigheder: Programmering af database, MySQL, PHP, Software Arkitektur, SQL

Se mere: how to connect excel to sql server 2012, how to connect excel to oracle database, excel connect to sql server and run query, excel connect to sql server vba, excel connect to sql server query, connect excel to sql server using odbc, excel sql connection string, excel connect to mysql server, mysql excel connection, excel connection mysql, mysql dot connect net database connection, paging pages database results including thumbnails php mysql, synchronize contacts outlook mysql open source, sql database convert joomla joomla php mysql, mysql query remote mysql database

Om arbejdsgiveren:
( 0 bedømmelser ) London, United Kingdom

Projekt-ID: #15622180

Tildelt til:


I can make this as expected, please contact me to discuss further Relevant Skills and Experience Worked on VBA and Databases for almost 7 years Proposed Milestones £18 GBP - Result

£18 GBP på 1 dag
(28 bedømmelser)
£20 GBP in 0 dage
(3 bedømmelser)

6 freelancers are bidding on average £23 for this job


Hi, I am 12 years experienced web developer expert in PHP . Relevant Skills and Experience PHP, MySql , Excel Proposed Milestones £55 GBP - For complete Work

£55 GBP in 0 dage
(75 bedømmelser)

Hi, Hope you doing well.I read your project description and very confident to handle this project perfectly Let's have a discussion, negotiate costing, timeline and then we proceed Thanks! Relevant Skills and Experien Mere

£16 GBP på 1 dag
(14 bedømmelser)

i can modify or rewrite the code with instructions for you.

£13 GBP på 1 dag
(5 bedømmelser)

I can do this project Stay tuned, I'm still working on this proposal.

£18 GBP på 1 dag
(0 bedømmelser)