Find Jobs
Hire Freelancers

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
Project ID: 4304427

About the project

17 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
17 freelancers are bidding on average $31 USD for this job
User Avatar
easy job. i can do it and deliver a working draft version for your testing within hours. regards Prem
$30 USD in 2 days
4.7 (179 reviews)
6.0
6.0
User Avatar
I can build the query you want today. I have 15 years experience. Donna
$30 USD in 1 day
4.8 (29 reviews)
5.7
5.7
User Avatar
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
$30 USD in 2 days
5.0 (37 reviews)
5.0
5.0
User Avatar
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
$30 USD in 2 days
5.0 (31 reviews)
4.3
4.3
User Avatar
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
$30 USD in 1 day
5.0 (7 reviews)
3.8
3.8
User Avatar
Hi, I have completed similar projects many time. Let me know if you are interested. Regards,
$30 USD in 2 days
4.8 (2 reviews)
3.2
3.2
User Avatar
Hi,We are Expert in this type of Applications,Please see PMB
$40 USD in 2 days
5.0 (2 reviews)
2.1
2.1
User Avatar
Ready to complete in 1 Hour. Please see PMB
$30 USD in 30 days
4.6 (1 review)
1.9
1.9
User Avatar
Hi! Ready to go Regards.
$30 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hello sir i have read your requirements and ready to work with you.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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!
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have understood your requirements and put a summary in separate post to you. Please read and communicate with me.
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Salam, Yes i can do it.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very proficient in db programming, including ms access, please let me help you, I will design u a tool to do this.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Access/Excel expert having 8+ years of IT experience. I can help you in doing your work. Please see your PM for more details.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Engage me and you'll get it in no time.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Happy to do this for you.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MOROCCO
tangier, Morocco
5.0
16
Payment method verified
Member since Jan 11, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.