Need a Access 2010 (or 2007) database that can:
1. Pull several .xls (or .xml) files from a external data (or from an ODBC source if possible)
2. Filter the imported data to required changes using queries
3. Update the filtered data to existing tables
4. Export table to a template .xls file.
The database needs to be user friendly in carrying out above tasks (ie use of buttons or VB to automate process).
Note: Due to the formatting nature of the source data, be aware that the database needs to pull data from different source files that each have different formatting.
More information can be requested via PM
15 freelancers are bidding on average $201 for this job
Hi, We are Pune (India) based firm working since 1996. We will complete your work in time. We provide online support for software and customer satisfaction is our goal. Please see the private message box. Regards
We are Access specialists in Italy and very interested to complete your project. Skilled in VB for Application programming of office automization. Please see PM.