HI
1. Import raw data(CSV format) in to ms access
2.Query information from the raw data(percentages based on the total of specific fields etc..)
3. Export result data into xls file
Sample raw CSV attached
HI
1. Import raw data(CSV format) in to ms access
2.Query information from the raw data(percentages based on the total of specific fields etc..)
3. Export result data into xls file
Sample raw CSV attached
What is the issue? What have you attempted? Have you used the Import/Export wizard? Built queries?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.