SQL Select,Insert,Update queries from Excel vba?

[ravikumar00008]

Hi All,


I am having an excel workbook with some sheets.From that i am able to read the current month and previous month sheets data and inserting those columns data into sql table.


But to avoid insertion of same data all the time,


I just want to check a condition like if particular columns of sql table data and excel sheets data may match then i want to update those records in the database otherwise i want to insert as new records in to the database.


Some part i am successfully done(like insertion) but


i am not succeeded at select statement in the code(to check the rows count based on conditions for columns data match) and

at updating those records if condition met.


http://speedy.sh/v9xnB/SQLInsertandUpdateBasedOnCondition.xlsm

http://speedy.sh/nAzNr/DatabaseAndTableCreation.txt


Please look at the sample files along with database creation and please provide any solution to solve my problem


Thanks for any help.


Regards

Kumar

 

[brigzy]

Hello Kumar,


I have posted something similar today you might find the answer useful:


http://leansoftware.net/tabid/123/g/posts/t/24/INSERT-or-UPDATE-or-DELETE.aspx

 

[SirJB7]

Hi, ravikumar00008!


Already checked this?

http://chandoo.org/wp/2012/04/02/using-excel-as-your-database/


You may find useful this guy topics:

http://chandoo.org/forums/profile/vijaysharma


Regards!

 

[brigzy]

Hi,

just to let you EDT (Excel database Tasks) makes light work of Edit/Insert from Excel.


Please see blog for new release details:

http://leansoftware.net/en-us/blog.aspx


Thank you for the interest

Richard

 

[SirJB7]

@brigzy

Hi!

Thanks for sharing with us the availability of a new version of a software product (called EDT, isn't it?) from an European developer (called LeanSoftwareLtd, isn't it?).

I think ravikumar00008 would highly appreciate your dedication and interest in updating your previous post from 5 months ago. If the user happens to pass by and enter here again. But, who knows? Maybe he check this for updates every week. So thank you again.

Regards!

PS: BTW, why does it sounds to me as surreptitious advertising? Surely because I'm so much suspicious. Surely, isn't it? One of myselfs is probably thinking that's because of my innate mixture of paranoia and schizophrenia. But I don't think so! And neither do I! Not me too, neither!