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

  • 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!