I would like to automatically populate my sql database with a .csv file that is created everyday and resides on my machine. I looked at some of the postings here but didn't quite get what I was looking for. Even if I were to use ODBC and Access how would I be able to automate the process of updating the sql database. Also is that the most efficient way to do it, if not, then what would be.
Thanks a lot.
