View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
labc labc is offline
external usenet poster
 
Posts: 1
Default connection to internet mysql-database

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" a écrit dans le message de news:
...
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