I have some data in a Microsoft Access Database. The data needs to be extracted in a form that I can load into a new system.
I've included a .ZIP file with the database (Microsoft Access) , a sample report from the system (PDF) , and the sample output that I need (Excel). I created the sample output file manually for the first 2 items in the report. I need all 1500 items done.
I don't have a data dictionary, but the the data appears to be relatively straightforward. It is "Bill of Materials" data.
## Deliverables
I need a coder to create an extract file that I can load into a new system.
I'm flexible in the output file, I can change things around as I load the data into the new system. It just all needs to be there.
Please review the Excel File and PDF Report for more details.
-----------------------------------------------
The original database was a Visual Foxpro system. It was a module called "Everest Manufacturing", tied to an accounting system called SBT. I don't have any documentation. The software hasn't been supported for a number of years, and the software company is out of business.
-----------------------------------------------
On an early version of my file, n the "Material" tab of the excel sheet, the the first 3 lines should be the first part (152130). The last 7 should be (152230). I didn't copy/paste enough.
------------------------
Update: I don't need an full-fledged application for this RAC project, this is a 1-time data conversion on my side. This is static data for a system conversion.
I don't need the program, just the converted data.