Thanks for your help.
Btw, I am working from VB6. When writing to Excel, would I be able to write cell by cell instead of column by column?
I supposed the code below writes column by column.
For i = 0 To 14
oRS.Fields(i).Value = oOrdersRS.Fields(i).Value
Next
My intention is to export data from a specific cell (eg. A3) in Excel spreadsheet to a column in a table in SQL Server. For Example: Cell B3 to Column1, Cell E4 to Column2, and so forth. My question is can it be accomplished using DTS? And if it can be done, where do I find the resources to...
I have recently acquire Crytal Analysis Professional 8.0. I would like to find the product's review and evaluation and over the web and also how does it compare to Business Object and Cognos.
Is there any website I could go to?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.