How to import csv files into ms access using visual basic

[wedd]

Hi experts, how to import csv files into ms access using visual basic. I would like to import csv files from excel 2007 into access on a click a button on a form into ms access. Can this done. if so how? Would you have any examples of code, websites or personal experience of what steps you did in handling this type of task?



Thanks for your contributions:friends:

[mohanvijay]

Try Recordset.Addnew in ADO

[wedd]

Hi, Mohanvijay! I'm a bit of a beginner with vba...would you be able to provide an example or maybe show me a website of how to write a Recordset.Addnew program in ADO? Thanks!

[mohanvijay]

http://msdn.microsoft.com/en-us/library/windows/desktop/ms680885(v=vs.85).aspx