connection form Excel

#1

Hello, how I can set connection from VBA Excel (MS Office 2003) to mySQL
base? Greeting!

#2

On 29 June, 16:36, "Melody" <MelodyWYTNI... (AT) op (DOT) p> wrote:

Quote:

Hello, how I can set connection from VBA Excel (MS Office 2003) to mySQL
base? Greeting!

Using the ODBC Connector.

Tell you what:
http://lmgtfy.com/?q=vba+excel+mysql

#3

On 30 June, 05:19, Michael Vilain <vil... (AT) NOspamcop (DOT) net> wrote:

Quote:

In article <i0d3t9$i2... (AT) news (DOT) onet.pl>, "Melody" <MelodyWYTNI... (AT) op (DOT) p
wrote:

Hello, how I can set connection from VBA Excel (MS Office 2003) to mySQL
base? Greeting!

There's either a language barrier going on here or you have a serious
lack of knowledge on how MySQL works.
I think you are reading this wrong

Quote:

1) MySQL server must be running on your system or on a remote system
with remote access enabled (most ISPs don't do that and companies won't
do it unless you're connected through a VPN)
I think that when they said "MySQL base" they mant "MySQL database".

No where did they suggest that they didn't have the MySQL server
running.

Quote:

2) ODBC middleware (see the MySQL site for where to download it) must be
installed

3) Excel must be setup to allow for import from remote sources. *You can
do an import directly in Excel, but I don't know if you can from VBA.

Yes, VBA can access ODBC data sources

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

connection form Excel

comp.databases.mysql comp.databases.mysql

connection form Excel - 06-29-2010 , 11:36 AM

Re: connection form Excel - 06-29-2010 , 12:03 PM

Re: connection form Excel - 06-30-2010 , 04:47 AM