Hi,

Background:

I'm trying to re-architect an ETL process from one ETL tool to another. The
current ETL tool runs on Windows, the new one runs on Unix. The source data
for the ETL process is a number of CSV and Excel workbooks. I don't want to
setup a Samba file server or FTP CSV files from Windows to Unix.

Possible Solution:

I'd like Excel to be the editor / UI for the end users (and it's something
they're already familiar with). When they save the workbook, I'd like all
worksheets to be "pushed" to SQL Server. The Unix ETL can then read the SQL
Server tables.

In pseudocode:

On Save
Loop over all worksheets
Save all data to (a remote) SQL Server database with table names
matching the worksheet names

Even better would be if a filtered result set in Excel was the result
written to SQL Server.

Any example VBA code for the Excel workbook macros would be greatly
appreciated!

Regards,
Scott