excel (vba) and sql server express

[muelle60]

Hello,

is it possible to load and save data in sql server express using vba code in
excel?

We want to create/delete tables, load and save data?

Thank you.

Regards
Christian

[NickHK]

Christian,
Certainly. Set a reference to ADODB, then use the .Command, .Connection and
..Recordset objects

You can execute pretty much any valid SQL statements with this, including
DDL statements.
There is also the ADX Extension (ADOX) that is designed to work with DDL
that may be useful.

NickHK

"muelle60" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> is it possible to load and save data in sql server express using vba code
in
> excel?
>
> We want to create/delete tables, load and save data?
>
> Thank you.
>
> Regards
> Christian