I am a business owner who needs to process data using Microsoft Access. On a weekly basis, I receive a CSV file with approximately 250,000 rows of data that consists of about 15 columns of data that I would like to process.
I have created tables that can show you what information I want to work with. I need to be able to use forms to select parameters (such as zip/postal code, city, date of license, etc.) so that I can generate a report that will give me a listing of all individuals who fall within those parameters. Then I need to export that report to an excel spreadsheet.
I plan to use those spreadsheets as mailmerge listings when I use Microsoft Publisher to send out email flyers to potential customers.
I have built the tables in a way that I want the data to look, but I want to have Access be able to take the raw data and put it into the table format when I want to update my information.
I know this is possibly hard to follow but would welcome more detailed Q/A.
I have attached some screen shots of some tables that I've been working with but I don't have time to lean all that I need to learn in order to process the data the way I want it.
I want to use Access or Excel to automatically produce a table or spreadsheet that I can dump into an Access database. The table will have to be the result of processing the raw CSV data so that it only uses the columns that I want to use and discard the columns that I do not need to see.
Then I want to use Access Forms to select parameters such as "Distance" or "Area", "LicYEAR" (which I want to be derived from the LicDate, "LicType", .... to become part of the criteria of the query in order to produce a result that can be output to a spreadsheet.
I would also like to be able to update the "email sent" field to checked when the spreadsheet has been generated.
I hope this makes sense. Thank you for your interest.