• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Export the Data from EXCEL to Access database

Hi Team,


Would you be able to provide me an sample code to export the data from an excel file to an already existing table in access database.


Thanks

Raghava Sharma
 
Hi, Raghava@rock!


If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s), maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.

http://chandoo.org/forums/topic/help-me-writing-vba-codes-for-exporting-and-importing-data-between-xls-and-mdb


Regards!
 
Good day Raghava@rock


I find it a lot easier to open up your access file and use the import function, during this you can import to a new table or append to an existing table, very easy and very quick.
 
Back
Top