connection to internet mysql-database

[masterphilch]

Hi

I established a connection to a database via "importing external data"
included in the excel-menu. Unfortunately, there's no such tool to write
data into a database. I just changed the sql-string an exept from an
error, the data is written into it. But I'v read that I can connect to a
database through proper vba-code. Can someone tell me if I have to link
other objects, which objects I have to declare a how I have to handle
them exactly.

thx a lot, if someone could give me a quite detailed response.

greez
masterphilch

[labc]

Hi,

I know the code for a access database. I don't know if these is the same
code for a sql database. I don't have sql server on my computer.

"masterphilch" <[email protected]> a écrit dans le message de news:
[email protected]...
> Hi
>
> I established a connection to a database via "importing external data"
> included in the excel-menu. Unfortunately, there's no such tool to write
> data into a database. I just changed the sql-string an exept from an
> error, the data is written into it. But I'v read that I can connect to a
> database through proper vba-code. Can someone tell me if I have to link
> other objects, which objects I have to declare a how I have to handle them
> exactly.
>
> thx a lot, if someone could give me a quite detailed response.
>
> greez
> masterphilch

[masterphilch]

Hi

I saw some connection-codes for access-databases, but they seem to be a
little different. Your code perhaps helps me to solve my problem.

labc wrote:
> Hi,
>
> I know the code for a access database. I don't know if these is the same
> code for a sql database. I don't have sql server on my computer.
>
> "masterphilch" <[email protected]> a écrit dans le message de news:
> [email protected]...
>
>>Hi
>>
>>I established a connection to a database via "importing external data"
>>included in the excel-menu. Unfortunately, there's no such tool to write
>>data into a database. I just changed the sql-string an exept from an
>>error, the data is written into it. But I'v read that I can connect to a
>>database through proper vba-code. Can someone tell me if I have to link
>>other objects, which objects I have to declare a how I have to handle them
>>exactly.
>>
>>thx a lot, if someone could give me a quite detailed response.
>>
>>greez
>>masterphilch
>
>
>

[GysdeJongh]

Hi,
look here for a demo :

http://thelabwiz.home.mindspring.com/mysql.html

hth
Gys


"masterphilch" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> I established a connection to a database via "importing external data"
> included in the excel-menu. Unfortunately, there's no such tool to write
> data into a database. I just changed the sql-string an exept from an
> error, the data is written into it. But I'v read that I can connect to a
> database through proper vba-code. Can someone tell me if I have to link
> other objects, which objects I have to declare a how I have to handle
> them exactly.
>
> thx a lot, if someone could give me a quite detailed response.
>
> greez
> masterphilch

[masterphilch]

I found the solution by myself:

Sub test5()
Dim qt As QueryTable
Dim sqlstring As String
Dim connstring As String
sqlstring = "Select * From *"
connstring = _
"ODBC;DSN=name_of_the_driver(individual);DATABASE=name_of_the_database;SERVER=ip_or_url;UID=user;PASSWORD=password"
With ActiveSheet.QueryTables.Add(Connection:=connstring, _
Destination:=Range("B1"), Sql:=sqlstring)
.Refresh
End With

End Sub


masterphilch wrote:
> Hi
>
> I established a connection to a database via "importing external data"
> included in the excel-menu. Unfortunately, there's no such tool to write
> data into a database. I just changed the sql-string an exept from an
> error, the data is written into it. But I'v read that I can connect to a
> database through proper vba-code. Can someone tell me if I have to link
> other objects, which objects I have to declare a how I have to handle
> them exactly.
>
> thx a lot, if someone could give me a quite detailed response.
>
> greez
> masterphilch