Vb: Read From Ado Cellset
March 23rd, 2009
No comments
I need someone who is capable of writing plain Visual Basic Code. The goal:
We execute a .vbs file on a server which will fetch data from an SAP BW. The necessary MDX queries have been created and are working. The data from SAP is being stored into an ADOMD.cellset. I need a piece of code which reads out all the data of the cellset (columns & rows) in a way that it can easily be written into a MSSQL2005 database.
Example approach: Write loops that fetch every row of the cellset. After each row, the row is being written into the SQL DB.
Sample code and more info (if needed is available).
Categories: MS SQL, Programming, Visual Basic ado, ado cellset, ado cellset programming, basic, cellset, cellset programming visual, Code, Data, from ado, programming visual basic, read, read from, row, SQL, visual, visual basic
