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

Taidot: Tietokantaohjelmointi, MySQL, PHP, tietojärjestelmäarkkitehtuuri, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) London, United Kingdom

Projektin tunnus: #15622180

Myönnetty käyttäjälle:


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 1 päivässä
(28 arvostelua)
20 £ GBP 0 päivässä
(3 arvostelua)

6 freelanceria on tarjonnut keskimäärin 23 £ tähän työhön


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 0 päivässä
(75 arvostelua)

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 Lisää

16 £ GBP 1 päivässä
(14 arvostelua)

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

13 £ GBP 1 päivässä
(5 arvostelua)

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

18 £ GBP 1 päivässä
(0 arvostelua)