|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
July 15th, 2003, 09:10 AM
|
|||
|
|||
|
Export Data to CSV from SQLServer tables
I have a SQLServer table with names of 160 tables. I need to write a VBScript which will read this table, get the table names sequentially and export to CSV files. Can anyone provide me with a script?
Thanks
|
|
#2
July 15th, 2003, 12:04 PM
|
|||
|
|||
|
I'm not going to write it for you, i'm sure it's out on the internet if you did a search, this is what you'd do though. (sudo code is free)
query db, order by names (column you want sequentially) create fso object or however else you want to write to the file do a loop for each entry in the record set write column1 & "," & column2 & "," etc.... & vbcrlf loop close file that's it, you're done
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Export Data to CSV from SQLServer tables |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
