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!
|