Post reply

Exported to Visual Basic - Now I need to run

  • February 27, 2013 at 10:25 am

    #290286

    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.

  • February 27, 2013 at 11:48 am

    #1591670

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 27, 2013 at 12:27 pm

    #1591679

    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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply