Find Jobs
Hire Freelancers

create simple .CSV file from an access query

£10-20 GBP

Completed
Posted about 5 years ago

£10-20 GBP

Paid on delivery
I work for a small charity in the UK. Our sql database holds a lot of financial information such as how much each event we run needs to be invoiced. As we are moving over the Xero we want to be able to transfer this data into Xero to create invoices. I have a query in Access, with data in that i need to export into a Xero csv template. i need some VBA writing so that : a: the export file matches exactly what Xero needs. b: the export file will also need to hold some information that may be dependent on the information in the query. For example: if there is a field in the query "Xero" called [cluster] then depending on the value of the field, I would like something different written in the output file. e.g. If [cluster] = I THEN [AccountCode] = 256 If [cluster] = A THEN [AccountCode] = 200 This is a fairly straighforward job, and I would hope to pick up on your code, and once i have the idea can tweak it to suit my needs. Thanks ian
Project ID: 18704076

About the project

15 proposals
Remote project
Active 5 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
Awarded to:
User Avatar
Hi, This seems to be a simple job to me. The only thing I need to clarify here is that I will create a console application using .Net Framework, so that you can use that application at a later stage as well. You can even use that application to schedule to run each time, once a day, or once every hour, so that it generates the CSV after that. Let me know if you think this is the right approach. Regards, Naveed
£27 GBP in 3 days
5.0 (3 reviews)
1.9
1.9
15 freelancers are bidding on average £31 GBP for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
£50 GBP in 1 day
5.0 (169 reviews)
7.7
7.7
User Avatar
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
£20 GBP in 1 day
4.9 (175 reviews)
6.7
6.7
User Avatar
Hello Ian, I will write this VBA code for creating CSV file to import into XERO. I have 5 years experience in MSAccess database, Sql, VBA programming. With Regards, Sai
£35 GBP in 1 day
4.9 (80 reviews)
5.7
5.7
User Avatar
I have excellent command on MS Access and VBA and can create the csv file in the necessary format. In addition to creating databases from scratch, I have also completed complex projects in Access VBA before . For instance - Buy and sell bitcoins automatically on Coinfloor and GDAX using respective APIs based on an algorithm - Get Amazon prices and store them in database tables periodically - Get daily orders from Amazon and update the changes in existing orders present in the database. You can see the reviews of the same in my profile. Thanks, Archana
£40 GBP in 1 day
4.8 (58 reviews)
5.6
5.6
User Avatar
Hi there, Greetings! I am an experienced MS Access developer. I have been developing custom database solutions for the past 10 years. I have excellent depth over MS Access, VBA, ADO, SQL, MySQL, Excel, and other Office applications. I understood your basic requirement, let's discuss this on the detail level. Thanks, Rayyan
£18 GBP in 1 day
5.0 (21 reviews)
4.9
4.9
User Avatar
Hello. Below is recent Access project completed by me: https://www.freelancer.com.ru/projects/excel/create-complex-report-from-table/?w=f I suggest to create dedicated query for entire task then when this table will be ready it can be exported to csv manually or using VBA script. I can help with this. It will require up to 1 day.
£31 GBP in 1 day
5.0 (19 reviews)
4.4
4.4
User Avatar
Hello, i am interested in this project , can begin now waiting your answer on chat Regards
£18 GBP in 1 day
4.8 (35 reviews)
4.2
4.2
User Avatar
helll sir, I'm consultant, trainer, SQL Server Administrator Transac-SQL Programmer with access, SQL server and visual basic cordially
£23 GBP in 3 days
5.0 (10 reviews)
3.6
3.6
User Avatar
Hello,  Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using my MS Access and VBA skills. I would very much enjoy having the opportunity to talk with you further to discuss the requirements and expectations regarding the project, and how I could use my skills to benefit you. Thank you for considering my application. I look forward to hearing from you. Regards,  Naveen Upadhyay
£15 GBP in 1 day
5.0 (6 reviews)
3.3
3.3
User Avatar
Hello, My name is Waseem, I'm expert in MS Access and VBA and have more than 10 years experience in building and developing MS Access Applications. I can help you in coding what you need. Please review my profile and see the feedback of my previous employers, you will know that my customer satisfaction is my top priority. Looking forward to hear from you. Thank you Waseem
£30 GBP in 1 day
5.0 (4 reviews)
3.2
3.2
User Avatar
Hi, I am very happy to bid your project. I read your requirements carefully,so i see what you mean. I have been experiments with Microsoft Access, Visual Basic I'd like to work with you. i'll complete this project for you to the best my ability and without condition I am looking forward to meeting you
£18 GBP in 1 day
5.0 (1 review)
2.8
2.8
User Avatar
Hi, my name is Esteban Salpeter and I'm an expert MS Access developer, with many years of experience on that platform. You can check out my portfolio to view some of my work. Your requirement is very clear, so the coding can be done easily. Feel free to ask me any questions before contracting. Hoping to start working together soon, Best regards, Esteban
£13 GBP in 1 day
5.0 (2 reviews)
2.2
2.2
User Avatar
Please review my profile I am working with skills that you required for this job from 16 years. I am working with MS Access,Excel,MS SQL and VBA from long time. I can definitely help you in this job, to make your database design very proficient. I have done lots of split databases with MS Access as Front-end and MS Access/MS SQL/MySQL/Teradata database as back-end. I will show my advanced skills in MS Access/Excel via arrange demo via screen sharing session etc. Please contact me with your interest to discuss next.
£111 GBP in 1 day
5.0 (3 reviews)
2.4
2.4
User Avatar
Hi. i am a full web developer with over 5 years on freelancer.com. ****SPECIAL .web Expert***** I have read your description and have interests in your project. I have rich experiences in projects similar to yours. I am ready for your project now. I would like to have a discussion on chat to get more about your project. Thanks.
£20 GBP in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Churchstoke, United Kingdom
4.9
3
Payment method verified
Member since Nov 11, 2008

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.