By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,487 Members | 1,801 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,487 IT Pros & Developers. It's quick & easy.

Convert all folder contents that are xls to csv

P: n/a
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.

Feb 21 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
jo********@comcast.net wrote:
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.

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.
Feb 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.