• "I feel your pain about Excel imports. If Excel and SQL Server weren't both MS products, I could understand the mismatches being a problem. MS clearly intended Excel to be a source/destination for SSIS: they didn't do their homework on this, IMO. "

    I started to use SSIS but gave up. VBA in Excel is easy to learn and you can run an Excel process

    on the client computer fetching data or importing data from/to a remote server. 🙂

    /Gosta