Access File Enhancement
$30-250 USD
Paid on delivery
Essentially what I need is to be able to take the data from the file 'Raw Data' & import it into the Access database (attached). The raw data will be imported in the same format every week. The trick is to add all new dates (column A) to the database base. However, I need to overwrite any data entries if there are dates currently in the database. In other words, if I import raw data & in that raw data there is a date of 6/5/14, then that would replace all of the dates 6/5/14 that are currently in the Access file. As mentioned several weeks ago, I need this to be easily updated since there will be new items added/removed every week. Thus, I would like it to where I can 'click a button' to import the new data & all of the worksheets will automatically refresh.
Project ID: #6260485
About the project
Awarded to:
I have been read your Project Description: (Essentially what I need is to be able to take the data from the file 'Raw Data' & import it into the Access database (attached). The raw data will be imported in the same fo More
12 freelancers are bidding on average $118 for this job
I have 15 years experience in access database design and development. I have completed well over 250 custom databases in this time. I have worked on existing databases and created from scratch. A list of some databases More
dearsir, I'm expertat access, and interested on doing your project, Kind regards, Noureldeen
Hello there. I just finished a similar project. It was a big project importing/exporting data from Excel into Access and vice versa, with forms, reports, modify Worksheet format, etc. So, this seem very easy. For your More
I am an experienced developer in VBA for both Microsoft Access and Excel. I have easy access to several import functions that I have written previously and update queries. I speak perfect English (native American) and More
hi there I really want to do the job. I will give you quality work on time. You can trust me. The rate is negotiable. Waiting for your response. thanks
Dear Sir, When you import new week the program work like this: - if date exist in xls and access then delete all data whit this date in access and import what is with this date from xls - if date exist in xls and More