MS-Access Export Text File Naming Convention
Posted on 2012-04-10
I'm not sure how difficult this is...but any help would be greatly appreciated. I have a table that I want to export into seperate files based on the data. For example:
Table X has the following fields:
Name (John Smith, Joanne Smithers, Jordan Simpson)
ItemCategory (Shirt, Shoes, Socks)
OrderDate (04/10/2012, 04/12/2012, 04/15/2012)
RecurringOrder (monthly, weekly, yearly)
I want to create seperate CSV files based on the ItemCategory, OrderDate, and RecurringOrder.
So, when someone imports the Socks_4-10-2012_weekly.csv - they'll be getting all the records in the table that are for Socks that were ordered on 4-10-2012 and has a recurringOrder of weekly.
How can I export these .csv files from the same table source?