Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact

A1VBCode Forums Home    Search    Members    Calendar    Who's On

Welcome Guest ( Login | Register )       Recent Posts    Popular Topics

Home » Classic Visual Basic (VB 6 or earlier) » VBA(Excel, Word, etc...) » help with excel and access importing

help with excel and access importing Rate Topic Display Mode Topic Options Author Message chaw12 Posted 10/23/2011 3:44:36 AM Forum Member Group: Forum Members Last Login: 11/17/2011 10:07:41 PM Posts: 53, Visits: 204 Hi to all! I've created a simple program which will import all the data in an excel file to a database or more likely inserting the excel data to access database. but can someone please help with this!. I want my program to automatically write all the duplicate data in a different sheet of the excel file if it has found a similar or existing data on the access database. And if there are some duplicate data found I want the excel to access importing to skip on it and continue saving all those other data that has no duplicate on the database. By the way I've create an excel template with an exporting button and it is where the code resides and the data will be encoded also on the template. Hope some would help me with this.. Thanks in advance! Post #30823 nichetech Posted 10/31/2011 8:42:26 AM Forum Newbie Group: Forum Members Last Login: 10/31/2011 8:47:18 AM Posts: 7, Visits: 5 Well mate this is something completely new to me. The comparisons and all and copying duplicate in next sheet. I hope you will get success and if possible please share your experience in here. Android Application Development | Android Application Developer | Web Development Firm Post #30850 « Prev Topic | Next Topic »

Reading This Topic Active Users: 1 (1 guest, 0 members, 0 anonymous members) No members currently viewing this topic. Forum Moderators: Admin, Mod, Mark, Keithuk

Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to polls. You cannot edit your own topics. You cannot delete your own topics. You cannot edit other topics. You cannot delete other topics. You cannot edit your own posts. You cannot edit other posts. You cannot delete your own posts. You cannot delete other posts. You cannot post events. You cannot edit your own events. You cannot edit other events. You cannot delete your own events. You cannot delete other events. You may send private messages. You cannot send email's. You may read topics. You cannot rate topics. You cannot vote within polls. You cannot upload attachments. You may download attachments. You cannot post HTML code. You cannot edit HTML code. You cannot post IFCode. You cannot post JavaScript. You cannot post EmotIcons. You cannot post or upload images.

Forum Jump...----------------Forum HomeSearchMembers ListCalendarWho's Online---------------- Announcements  |-- Announcements .NET Programming (VB 2010 or earlier)  |-- Visual Basic .NET  |-- ASP.NET  |-- C# Classic Visual Basic (VB 6 or earlier)  |-- General Visual Basic  |-- Database Programming  |-- COM/ActiveX  |-- API  |-- Internet/Communications Programming  |-- VBA(Excel, Word, etc...)  |-- Game Programming General Discussion  |-- Forum Feedback  |-- Member Chat  |-- Introductions All times are GMT -5:00, Time now is 2:26am