Convert excel to access
Budget: £20 – £250 GBP
I am looking for a freelancer who can help me convert a large Excel file (more than 5MB) into an Access database.
Presently the file is used as an invoicing system to generate invoices and save information. This is it's primary function. There is additional recording with each invoice showing manufacturing details.
Requirements:
- The data should be updated in both Excel and Access after conversion.
- I need the Access database to have reporting and analysis features.
-The file has a few macros which are used to generate PDF invoices and save them to a folder.
-I want to ensure I can see the information and use filters in the same way as I can in excel - so we don't need a special form to display the data.
Ideal skills and experience:
- Strong knowledge and experience in Excel and Access.
- Proficiency in data conversion and database management.
- Experience in creating reports and performing data analysis in Access.
If you have the skills and experience required for this project, please submit your proposal.
Presently the file is used as an invoicing system to generate invoices and save information. This is it's primary function. There is additional recording with each invoice showing manufacturing details.
Requirements:
- The data should be updated in both Excel and Access after conversion.
- I need the Access database to have reporting and analysis features.
-The file has a few macros which are used to generate PDF invoices and save them to a folder.
-I want to ensure I can see the information and use filters in the same way as I can in excel - so we don't need a special form to display the data.
Ideal skills and experience:
- Strong knowledge and experience in Excel and Access.
- Proficiency in data conversion and database management.
- Experience in creating reports and performing data analysis in Access.
If you have the skills and experience required for this project, please submit your proposal.