| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel (vba) and sql server express
Thanks. Can please give me an example?
Regards Christian NickHK wrote: 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" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
| how to express dan < using excel? | Excel Worksheet Functions | |||
| Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
| Excel with Outlook Express | Excel Programming | |||
| Excel with Outlook Express | Excel Programming | |||
Threaded Mode
