InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 09:57:46 GMT20http://www.sqlservercentral.com/Forums/Topic1424640-9-1.aspxUsing DTS Wizard, I followed the process of setting up which tables that I wanted to export out of SQL and into an Excel spreadsheet. I chose Visual Basic file in the last screen. I needed to be able to edit the file to constrict one of the exported tables by data range (I did not know how to do this otherwise using the DTS package file, sorry). I thought that if the DTS Wizard would allow me to create a file (like .bas or dts, for that matter) then it would give me the ability to also process, but i was unable to find a way to do so.Wed, 27 Feb 2013 12:27:37 GMTdlangschiedhttp://www.sqlservercentral.com/Forums/Topic1424640-9-1.aspx[quote][b]dlangschied (2/27/2013)[/b][hr]I needed to export some data from SQL 2000 database to Excel. I only needed a portion of two of the tables, so I generated as a Visual Basic File. I am trying to figure out how to run the file, so that I can extract my data. Do I need to have Visual Basic installed on the server? I do not, but I will.[/quote]what is a Visual Basic File to you? How Did you generate the file?Most exports are some type of plain text in a flat file...is that what you are referring to?VBA(Visual Basic for Applications) is installed by default, which is basically the scripting language version of VB, so you can create a *.vbs file with the commands, and use that without installing the full vb6, but it really depends a lot of the details.Wed, 27 Feb 2013 11:48:58 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1424640-9-1.aspxI needed to export some data from SQL 2000 database to Excel. I only needed a portion of two of the tables, so I generated as a Visual Basic File. I am trying to figure out how to run the file, so that I can extract my data. Do I need to have Visual Basic installed on the server? I do not, but I will.Wed, 27 Feb 2013 10:25:19 GMTdlangschied