Sedang Disiapkan

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;" & _

"Option=3"

End Sub

Kemahiran: Pengaturcaraan Pangkalan Data, MySQL, PHP, Kejuruteraan Perisian, SQL

Lihat lebih lanjut: 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

Tentang Majikan:
( 0 ulasan ) London, United Kingdom

ID Projek: #15622180

Dianugerahkan kepada:

prabakarm23

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 dalam sehari
(28 Ulasan)
4.6
£20 GBP dalam 0 hari
(3 Ulasan)
2.1

6 freelancers are bidding on average £23 for this job

bhaskarmandal

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 dalam 0 hari
(75 Ulasan)
6.0
ahmadmtii

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 Lagi

£16 GBP dalam sehari
(14 Ulasan)
4.0
sambayour

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

£13 GBP dalam sehari
(5 Ulasan)
2.6
subroto2017

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

£18 GBP dalam sehari
(0 Ulasan)
0.0