• 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.

Help me writing VBA codes for exporting and importing data between xls and mdb.

ADO.


http://www.exceltip.com/st/Import_data_from_Access_to_Excel_%28ADO%29_using_VBA_in_Microsoft_Excel/427.html


http://www.exceltip.com/st/Export_data_from_Excel_to_Access_%28ADO%29_using_VBA_in_Microsoft_Excel/425.html


At this point, I've had quite a bit of call to get data from a database and into excel, but not vice versa. Apparently, I don't swing that way.


Let me know if you have any questions.
 
ADO.


http://www.exceltip.com/st/Import_data_from_Access_to_Excel_%28ADO%29_using_VBA_in_Microsoft_Excel/427.html


http://www.exceltip.com/st/Export_data_from_Excel_to_Access_%28ADO%29_using_VBA_in_Microsoft_Excel/425.html


At this point, I've had quite a bit of call to get data from a database and into excel, but not vice versa. Apparently, I don't swing that way.


Let me know if you have any questions.
 
You'll need to try ado.


http://www.exceltip.com/st/Import_data_from_Access_to_Excel_%28ADO%29_using_VBA_in_Microsoft_Excel/427.html


http://www.exceltip.com/st/Export_data_from_Excel_to_Access_%28ADO%29_using_VBA_in_Microsoft_Excel/425.html


At this point, I've had quite a bit of call to get data from a database and into excel, but not vice versa. Apparently, I don't swing that way.


Let me know if you have any questions.
 
You'll need to use ADO. the first 2 links will do it:


http://www.google.com/search?q=ado+access+excel&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:eek:fficial&client=firefox-a
 
You must log in or register to reply here.
Back
Top