Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to send data from Excel to a Database
I'm familiar with pulling data into Excel from an external
datasource, but can it push data into an external source (e.g. Access or any other ODBC database) and how? I've been struggling with the QueryTables method and building an INSERT query to no avail. Thanks in advance. Bob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to send data from Excel to a Database
http://www.erlandsendata.no/english/vba/adodao/ http://support.microsoft.com/?kbid=257819 HOWTO: Use ADO with Excel Data from Visual Basic or VBA http://support.microsoft.com/?kbid=278973 SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel Workbooks -- Regards, Tom Ogilvy Bob wrote in message ... I'm familiar with pulling data into Excel from an external datasource, but can it push data into an external source (e.g. Access or any other ODBC database) and how? I've been struggling with the QueryTables method and building an INSERT query to no avail. Thanks in advance. Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How do I send data to a person or BCC a group in excel? | Excel Discussion (Misc queries) | |||
My send to in excel/word does not offer send as attachment | Excel Discussion (Misc queries) | |||
how i make the excel send data or save it to another bad file | Excel Worksheet Functions | |||
Send Excel data to Access through button | Excel Discussion (Misc queries) |