View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default Export table to SQL

Sure it is possible. You need to understand ADO, SQL (enough to create a
query) and have the ODBC drivers.

I can give you some code that I Use to update a table in Access. The only
difference is the Connection...

If you want the code let me know...

"winter" wrote:

I want to write some VBA code to export a worksheet in excel to a table in
SQL. Is that possible? Thanks a lot!