cikaPero's Feed - Programmer's Heaven

Re: port data from MS Excel to SQL Server 2000

Mon, 08 Mar 2010 02:51:59 -0700

Posted a 'reply on the VB.NET forum.

Hi,

you can easily import Excel to DataTable with this Excel VB.NET library.

After that with DataAdapters and ADO.NET you can update SQL database.
For Updating Data Sources with DataAdapters see this link.

Re: VB .NET Excel question

Fri, 19 Feb 2010 08:09:18 -0700

Posted a 'reply on the VB.NET forum.

Hi,

you are probably missing reference to Excel Automation library.
But I recommend you to stop working with Excel Interop, it has a lot of problems. One major problem is if there are different versions of Excel installed in development and production environment - then everything falls apart.

For Excel C# and Excel VB.NET applications I use GemBox.Spreadsheet .NET Excel component.

Much more easier to use and much more faster that Excel Interop.

Automate AdWords campaigns

Fri, 18 Dec 2009 08:22:59 -0700

Posted a 'new message on the General programming forum.

Hi,

I am using AdWords for advertising my products. But in a last couple of months number of products have doubled so I don't have enough time to optimize AdWords campaigns for all of them. Some campaigns have thousands of keywords so I am looking a way to automate my AdWords campaigns.

I know about AdWords API and client libraries. I have been investigating them for some time and they are not so easy to use. I want to focus more on optimizing my AdWords campaigns, and not on communication with AdWords server.

Does anyone know about some C#/VB.NET library that would allow me to download my AdWords data, investigate it, modify it and then upload modifications back on AdWords server?

Thank you,
Pero