VB to Excelsheet?

Question

I want to send a data which is a output of my sqlquery on VB from to MS Excel sheet. How to send that data??

Answer 1

You need to modify that VB script to export the sqlsuery into CSV file

CSV file is an ASCII file with values seperated with comma (Comma Seperated Values)



Then double click on any CSV file will open it in Excel



Ejoy my profile, I am the VBAXLMan

Answer 2

I think your question is not that clear. If you mean you get data by using vb language from excel, where to transfer the data ? To another excel sheet ?

Or if you mean you just want to transfer a data in a vb program to ms excel ?

Answer 3

The URL in the reference i pasted below has an example of the code you are after.....



If you are interested...

Usually if I need to quickly generate an excel file, I just generate a HTML code with a table having my rows and column and then save the file with a .xls extension. Excel with will able to interpret it.



Create a text file with the below content and save it with a file name test.xls

col1	col2
row1	row1.1
row2	row2.1