Exported to Visual Basic - Now I need to run

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » Exported to Visual Basic - Now I need to run

Exported to Visual Basic - Now I need to run

Rate Topic

Display Mode

Topic Options

Author

Message

dlangschied

Posted Wednesday, February 27, 2013 10:25 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, April 19, 2013 9:11 AM
Points: 15, Visits: 32

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

Lowell

Posted Wednesday, February 27, 2013 11:48 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 10:50 AM
Points: 11,605, Visits: 27,647

dlangschied (2/27/2013)

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

dlangschied

Posted Wednesday, February 27, 2013 12:27 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, April 19, 2013 9:11 AM
Points: 15, Visits: 32

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 »

Permissions