Need Help excel to access conversion using vb6

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • elbatz
    New Member
    • Dec 2007
    • 14

    Need Help excel to access conversion using vb6

    Hello.Does anyone here know how to convert or export data from excel to access database having an existing table using visual basic 6 codes?
    And if that data in excel already exist in access database it should not be inserted or maybe the old records be replaced.plss help me.i do not know how to code it.it's urgent..thanks a lot..
  • Dököll
    Recognized Expert Top Contributor
    • Nov 2006
    • 2379

    #2
    Originally posted by elbatz
    Hello.Does anyone here know how to convert or export data from excel to access database having an existing table using visual basic 6 codes?
    And if that data in excel already exist in access database it should not be inserted or maybe the old records be replaced.plss help me.i do not know how to code it.it's urgent..thanks a lot..
    Hey, elbatz!

    You will be able to find answers here if you fetch deeper into the pages. If you did not find anything, will try and Google an example for you. Also I may hav a code somewhere that does this. Just haven;t worked too much with Excel and Access through VB.

    Good luck, and please stay tuned!

    Dököll

    Comment

    Working...