jon.ingram@comcast.net wrote:[color=blue]
> I need some vb code that I could perhaps run from access that will look
>
> in a particular folder I could specify in the code, and convert all the
>
> files (just excel are saved there) to .csv. Is this possible? This
> would be a huge help for me and any help would be greatly appreciated.
>
> Also, there are only 5 files in the folder (the folder path never
> changes) but they are updated monthly so if we cant evaluate the entire
>
> population that is in the folder and have to write seperate code to
> convert each file that is cool too.
>
>
> Here is my process:
>
>
> Excel Files Updated and saved to directory ---> Saved as csv in same
> directory---> Imported in Access ---> Access Reports Runs --->Done
>
>
> I would love to have all this done in a click of a button, im so close
> I just need to get this conversion to csv piece.
>
>
> Thanks.
>[/color]
Why not link the Excel files to Access? The folder path never
changes...what about the filenames? If they did change, you could make
2 copies...one to the original filename, the other to the linked file
name. This way you'd have you 5 static names and a backup copy for each
month.
If your reports are already written, then you could write a small import
routine to update Access tables with the Excel data contained in the
linked tables via some update queries.
Convert all folder contents that are xls to csv 
