Hello All,

I am interested in downloading data that is saved in csv format. Every day a new file is posted to a website, and I have a utility that saves the file to a folder on my pc. I need to write code that opens the file, inserts a column, writes a formula based on an adjacent column, and imports the data into access.

can anyone tell me how to do this or point me in the right direction?

Any help will be greatly appreciated.

Thanks!