Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Exported to Visual Basic - Now I need to run Expand / Collapse
Author
Message
Posted Wednesday, February 27, 2013 10:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 3, 2013 9:08 AM
Points: 15, Visits: 33
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.

Post #1424640
Posted Wednesday, February 27, 2013 11:48 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:39 PM
Points: 12,903, Visits: 32,143
dlangschied (2/27/2013)
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.



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.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1424675
Posted Wednesday, February 27, 2013 12:27 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 3, 2013 9:08 AM
Points: 15, Visits: 33
Using 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.

Post #1424685
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse