Закрито

MS ACCESS -Create a table that can be used to track debtors

Hi

For a electrical company in Cape Town

So have a excel sheet(csv) with all the out standings /debtors from the accounting system.

I want to do it in MSaccess(2016) instead of EXcel as access more robust

CSV can be imported from excel into a Access table as a linked table.

What I want to do in Access is have extra columns on the database(linked table) to write updated comments or create two new fields which can be worked on to give a status update.

Issue is that if the sheet is updated(from excel which comes from Accounting system) it needs to keep those updated comments relating to that client if money still owing and if the client has paid the line will disappear as client not on outstanding anymore or not on excel sheet anymore

Could this be done and how much?

Навички: Microsoft Access

Показати більше: ms access stack table, ms access create table show, create table ms access, asp create table ms access facebook, create table access xml schema, create table access column format, create table xml access, create table microsoft access, create table access database odbc, create table access using, create table access database, access create table text, access database create table, access create table, create table access

Про роботодавця:
( 0 відгуки(-ів) ) South Africa

ID проекту: #15740512

14 фрілансерів(-и) у середньому готові виконати цю роботу за $41

$94 USD за 1 день
(74 відгуків(-и))
7.2
zu02

Hi, dear Yes it possible to code . I can build ms Access app with Excel automation . And the price will be $200 usd during 4-5 days. But I am ready for discuss... Regards, Zura Relevant Skills and Experience ms Acce Більше

$25 USD за 1 день
(38 відгуків(-и))
6.0
VladimirLilenko

I am ready to carry out your project in the shortest possible time and with the highest quality! Соответствующие навыки и опыт Access, Excel, vba, SQL Предлагаемые промежуточные платежи $30 USD - Project completed Y Більше

$30 USD за 2 дні(-в)
(57 відгуків(-и))
5.3
royalcalif

"Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. Thank you very much for your opportunity to bid" Relevant Skills and Experienc Більше

$30 USD за 1 день
(35 відгуків(-и))
5.3
alaeddindhahri

Hi, I'm a professional Ms Access developer. I have solid experience with automation and imports from CSV file. I'd like to help you with this app. Check my profile for similar previous projects. Relevant Skills and Ex Більше

$35 USD за 1 день
(48 відгуків(-и))
5.3
jonathanpradas

I believe that what you wanted is pretty doable using MS Access considering that there's a unique identifier from the excel sheet e.g. Transaction ID. Feel free to message me so that we can discuss. Relevant Skills an Більше

$30 USD за 1 день
(26 відгуків(-и))
4.3
schoudhary1553

Greetings, I can help you in MS ACCESS -Create a table that can be used to track debtors. Please ping me for more discussion. i have deliver almost 280 projects with 100% client satisfaction. Relevant Skills and E Більше

$100 USD за 1 день
(7 відгуків(-и))
4.4
selbyabraham

i am ready and fast to deliver this work and very confidential to my duties Relevant Skills and Experience i have much competence in these. Stay tuned, I'm still working on this proposal.

$25 USD за 1 день
(0 відгуків(-и))
0.0
jfuryu

I can provide a workable solution. Relevant Skills and Experience Excel, Access, VBA, database design and management Fullstack developer Financial Analyst Proposed Milestones $25 USD - Provide workable solution

$25 USD за 1 день
(0 відгуків(-и))
0.0
insidenetsoft

Hello, The code has to be analyzed then the procedure that imports from excel should be modified in order to add the new conditions regarding the new fields. Relevant Skills and Experience - Excel VBA developmen Більше

$60 USD за 3 дні(-в)
(0 відгуків(-и))
0.0
aaukaywah

I can use bau db ([url removed, login to view]) that is equipped with CSV importing feature and can add extra fields easily in an Access database. The input data can also easily exported to Excel. Relevant Skills and Experience I Більше

$35 USD за 1 день
(0 відгуків(-и))
0.0
freelancersree24

Senior Microsoft Access Database Developer with a total of 7 years of experience. Please mention your specifics and requirements over the chat and then award my bid for the project so I can start the with soon.

$30 USD за 5 дні(-в)
(0 відгуків(-и))
0.0
vw7883279vw

I am MS Access programmer with more than 15 years of experience My history is empty because I am new here, in Freelancer. Relevant Skills and Experience I work in MS Access every day for more in 15 years. Stay tune Більше

$25 USD за 1 день
(0 відгуків(-и))
0.0
$25 USD за 1 день
(0 відгуків(-и))
0.0