View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob[_32_] Bob[_32_] is offline
external usenet poster
 
Posts: 1
Default 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