VBScript – Loop through Excel Sheets Export as Tab Delimited File
This VBS script is easy to use and read. It loops through the tabs in the spreadsheet and saves each sheet as a “Tab Delimited File”. The script also creates the corresponding BCP command to upload to your Sybase Server. You can modify if needed to suit another database platform. ‘==================================== ‘Date Created: 2012_08_11
