Simple Monthly Report of Imported CSV Data. is project number 140692
posted at Freelancer.com. Click here to post your own project.
Bid Count: 13
Average Bid:
N/A
05/03/2007 at 16:46 EDT
Project Creator:
bjacobi
Employer Rating: ![]()
![]()
![]()
![]()
![]()
![]()
![]()
![]()
![]()
(4 reviews)
04/23/2007 at 20:05 EDT:
I need to know who the new permit numbers are each month while maintaining a master database. The permit number never changes for a business location, they just renew their permit yearly.
04/23/2007 at 20:31 EDT:
I will manually import the CSV data. The only querying I would need is to know who the new permit numbers were at the time of each monthly import of the CSV data. Each monthly import may consist of importing multiple CSV files. I need to know the new permit numbers at the time of the import as well as look back at previous imports & determine who the new permit numbers were at that time.
04/23/2007 at 20:47 EDT:
Here is a sample file I would be importing each month.
04/23/2007 at 21:56 EDT:
I want to keep all records imported. I don't want to only apend the records with new license numbers to the existing data. This way I can get a historical view of any one business, at any point in time.
I want to do one import a month. When I run the import I want to select multiple CSV files and import them at once. This import will be referenced as the date the import was executed.
I want a report generated, based on that import date, detailing which license numbers are new.
I would prefer this be done in MS Access or functional in Open Office.
Thank you for all of your interest!
|
Job Type |
|
Bids are hidden by the project creator.
Log in as the project creator or as one of the bidders to view bids. You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here. |