Hi, I am trying to make a little app that will help at work. It's about 8 years since i did any VB and I realised after I started I don't remember anything, and was never very good to start with! Add to that that this is VB.Net which is completely new to me. VS 2010 is also so different from what I used before I'm really stuck. The trial of VS 2010 expires in 90 days I think so I need to get moving.

I want to connect to Sage Data, to the stock table, and select certain columns such as SKU, title, description, sales price and then select the rows I want and send these to an excel spreadsheet formatted in the style required for upload as product feeds to google shopping, shopzilla, amazon and Ebay etc.

Each feed is formatted differently and I have to create these manually all the time so I want to try and automate the process. We would have much better control of our ecommerce if I could do this quickly with custom program.


So far I have managed, after a lot of disappointments, to connect to the sage data through the sage ODBC and populate a datagridview. I've only got this far by luck, with many errors due to me and system and software problems. I thought this would be relatively easy as I once used an app to create a word document programmatically with a very thorough guide, it's not looking so easy now. I have also added a check box column to the datagridview for selecting rows and thats as far as I have got.

I was thinking perhaps of passing the selected data to an array and then creating and populating the spreadsheet. Any ideas on how to proceed with this? I haven't figured out how to get selected rows from DGV.

If i had some clues to the steps I should take to achieve this i can look for tutorials on those steps and maybe kickstart my memory!


Best regards skaman