Everyday We have an Excel with all information about our ítems (sales, inventory, ...) and I need an application thqat automatically load this Excel file data into an Access database table. From the Excel file name it needs to take the date and load all records from the Excel file (just Sheet 1). Attached you have the Access(the table has already data from 1 Excel file as an example) and some examples of the Excel files to load. The application has to ask for the Access file and the folder where the Excel files to load are, and it should load all records from all Excel files into the Access ITB table. If the Access file has already records from the Excel file (based on the date of the Excel) it has to delete all records from this date first.
The older Excel files don´t have all of the columns as the new ones so we will load just what we have, they should have the same names of the columns always, please check it.
Access and examples of the source excel files. The table is already created and from the excel we just need sheet1. Please check old excel files to review if the columns are all the same and can be loaded (the newer ones have more columns). The date for access table has to be taken from each excel file name.
32 freelancers are bidding on average $122 for this job
I had created a tool similar to this one in past for one of clients... Please check the video of how it works..I can develop similar for you. [url removed, login to view]
Hi, Having more than 12 years of experience in development.I have done so many access application. I am ready to start immediately. Please send excel and access file . Thanks Chetnaa Desai
I have +4 year experiences in ms access database with export import data through excel . To provide quality , result oriented and supportive work. Thanks & Regards Hardik Dumaswala
Hello, I can develop your application. I'm a Freelance With 10 Years of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public And Private Sector.