Deleting and replacing all records from acces with import

Cancelled

Description

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

Skills: Microsoft Access

See more: microsoft acces, deleting, database record keeping, excel access table, access query table, access query excel, excel access import data, microsoft access record keeping database, access table query, excel import access, excel import data access, access record keeping, import excel file, access database record keeping, record keeping access database, microsoft access record keeping, record keeping database, record keeping access, record keeping database access, excel access update table, access rows, access table update excel, adding rows, gravity forms import csv records, content import

Project ID: #4304427

17 freelancers are bidding on average $31 for this job

Premshanks

easy job. i can do it and deliver a working draft version for your testing within hours. regards Prem

$30 USD in 2 days
(179 Reviews)
6.0
kulhanekd

I can build the query you want today. I have 15 years experience. Donna

$30 USD in 1 day
(29 Reviews)
5.7
amcsummers

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 year More

$30 USD in 2 days
(37 Reviews)
5.0
emova

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 b More

$30 USD in 2 days
(31 Reviews)
4.3
piyushdpatel

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
(7 Reviews)
3.8
SajjadHussain14

Hi, I have completed similar projects many time. Let me know if you are interested. Regards,

$30 USD in 2 days
(2 Reviews)
3.2
srdas2012

Hi,We are Expert in this type of Applications,Please see PMB

$40 USD in 2 days
(2 Reviews)
2.1
srikartiram

Ready to complete in 1 Hour. Please see PMB

$30 USD in 30 days
(1 Review)
1.9
BoydMT

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 se More

$30 USD in 1 day
(0 Reviews)
0.0
hegemon88

Engage me and you'll get it in no time.

$30 USD in 1 day
(0 Reviews)
0.0
ExpertoAccess

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 More

$35 USD in 1 day
(0 Reviews)
0.0
designjudd

Happy to do this for you.

$30 USD in 1 day
(0 Reviews)
0.0
bubu77

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 Reviews)
0.0
akramkhlouf

Salam, Yes i can do it.

$30 USD in 2 days
(0 Reviews)
0.0
rathodbharat

hello sir i have read your requirements and ready to work with you.

$30 USD in 1 day
(0 Reviews)
0.0
JackBradford

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 More

$30 USD in 1 day
(0 Reviews)
0.0
dohko1911

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 Reviews)
0.0
umbrellagroupbg

Hi! Ready to go Regards.

$30 USD in 0 days
(0 Reviews)
0.0
hbxfnzwpf

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 Reviews)
0.0