Unanswered: Is it possible to use DTS dynamically via vb ?
I have an application that would benefit from users specifying the file name and worksheet name to import, I have to admit that I haven’t worked with dts programmatically. Though I am having difficulties manipulating the .bas module. It seems to be only working with the saved dts settings. Maybe I am not configuring my goPacket properly.
Are these all I need to change to make dynamic
2)oConnection.DataSource = "C:\Updated Rotawin 15012002\Rosta_Workbook1.xls"