Deleting and replacing all records from acces with import
$30 USD
Cancelled
Posted about 11 years ago
$30 USD
Paid on delivery
I have an small access database, with some couple of tables.
Those tables have been imported and created initially from excel files.
The tables have multiple record in them (3 of them are similar in all tables), so relations have been set between them.
But i need to update the table every week, by deleting the table content (all records and rows) and adding the new data to it witch is different in terms of records and data. This cannot be done manually by reimporting the excel file to the existing database because there are different records and also because there are relations built between the 3 records.
I need you make it possible through a query for example to : delete all table data (records and rows) and replacing it with excel import with the new data (new records and rows) ad keeping the same relations built before for the table, knowing that the new data will contain each time the 3 records related to other tables.
That's it
Sounds pretty straight forward.
For the past 15 years I have worked with Excel/MS Access and 11 years with MS SQL Server 7.0 and 2005. I have been doing my contracting work with VWorker/Freelancer for the past 3 years; during that time I have completed 70 projects ranging from Excel/Access VBA to SQL Server database constructions. In my experiences over the past 3 years I know how daunting it is to try and describe what you are wanting along with sifting through numerous bids. As you can see from my reviews I strive to make sure my customers are happy with my services. I take a lot of pride in my work and stand behind anything I create so if you ever encounter a problem just email me Please feel free to ask any questions I am always willing to share my experience.
Best of luck with your search.
Michael
Hi. I'm vast and highly proficient in MS Access. I understand from your project description that you need to be able to easily delete previous records whenever you import records from excel and maintain the relations between the tables. I'll get this excelllently done for you given this job.
Kind Regards.
Emmanuel
Hi This is Piyush Patel
I have 8 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess.
I have developed many applications in VB6,VBA,VB.NET.
Please Check My PM
Hello.
I have been working with VBA, SQL (Access) and MS Office for over 10 years. Feel free to review my feedback. I can get this done for you quickly and easily in less than 2 hours. Let me know if I may be of service. Thanks!
This I can do with a button where you can import the excel file to a temporary table and then run update queries to the tables defined in your system will not need to modify your tables and will comply with the request. and all that in one day Greetings.
I feel fully capable of creating a VBA module that will automate the process of deleting, then re-importing your Excel files. My code is very clean, efficient and easily to follow. I have immediate availability, and see no issues with turning the project around in a timely fashion.