Search results for query: *

Thanks for the input Simi. I come from a Visual Foxpro background and it only takes a single line to do what I wanted. Learning to do things in Access is going to be an up hill battle.

I have a table that has 3 columns: serial# consumption datetime And a large csv file that is already formatted to match the table. I would like to import only those records in the csv that have a specific date and time. I would like to automate this process so can someone point me to some...

Thanks everyone for the input. I realized the same thing Rick was pointing out after a short break, Excel is doing the saving and thus must be tackled within Excel. The DisplayAlerts is what I needed to suppress the warning, thx JRB-Bldr.

I'm trying to open excel file from one folder, edit excel file and save it to another folder under a different name. All works well but if a file with that name exists in the destination folder excel pops up with a "file already exists...do you want to overwrite it..bla bla". I thought that...