How to export a SQL View to CSV using VBScript

RE: How to export a SQL View to CSV using VBScript (dm_4ever)

Tue, 17 Jul 2007 20:30:33 GMT

I don't see why it wouldn't be possible with the right SQL query.

RE: How to export a SQL View to CSV using VBScript (peachtea)

Tue, 17 Jul 2007 20:03:57 GMT

hi there... just a qn to hijack this thread

is it possible for vb script to pick up certain information from 2 separate access tables and insert them into the 3rd table before export it out to a csv file?
All 3 tables r in the same db

Thanks in advance :)

RE: How to export a SQL View to CSV using VBScript (VBNewbie07)

Thu, 03 May 2007 05:58:18 GMT

Thanks dm_4ever!

I'll give it a try.

RE: How to export a SQL View to CSV using VBScript (dm_4ever)

Wed, 02 May 2007 18:19:12 GMT

Not certain, but you can export to a csv from an Access DB like this...

 Option Explicit
 
 Dim strDBPath : strDBPath = "c:\temp\test.mdb"
 Dim strCSVDirPath : strCSVDirPath = "c:\temp\"
 Dim strCSVFileName : strCSVFileName = "CSVExport.csv" 
 Dim strTableName : strTableName = "SomeTable" 
 Dim objConnection : Set objConnection = CreateObject("ADODB.Connection")
 objConnection.Open "Provider = Microsoft.Jet.OLEDB.4.0; " & _
                       "Data Source = " & strDBPath  
 Dim commandstring : commandstring = "SELECT * INTO [text;HDR=Yes;Database=" & _
                                     strCSVDirPath & "]." & strCSVFileName & _
                                     " FROM " & strTableName
 objConnection.Execute commandstring

You might be able to modify this to export from an SQL server...not sure though... You might also just query the Table using ADO and use the GetString method to format the data and write it out to a .csv file.

How to export a SQL View to CSV using VBScript (VBNewbie07)

Wed, 02 May 2007 12:50:58 GMT

Hi all.

I would like to know if there is way to export a SQL View to a csv file using VBScript?

Thank you in advance!