Tag Archives: Excel

Macro DTS import of Excel spreadsheet failing

Quite a few years ago, I did an automated upload of pricing information from an Excel spreadsheet into a MS SQL database table. The VBA macro created a new spreadsheet with the required data from the Excel worksheet and saved it in a transfer folder. The macro then fired off a DTS package to upload […]

Posted in MS Office | Also tagged , | Leave a comment