Completed

create simple .CSV file from an access query

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

Skills: Microsoft Access, Visual Basic

See more: excel link worksheet to csv file, import csv file into excel programmatically, sql query to export data to csv, query csv file python, use power query to create a query and load data from a csv file into a new table as follows:, access export to csv vba, access 2013 export to csv, excel query csv file, sql create table csv file, mysql create table csv file, sql server create tabel csv file, create cloums csv file, create table csv file plsql, create table csv file, create chart csv file, asp upload csv file access database expertsexchange, bridge csv file access, create simple inventory database access, create simple database using access, import csv file access aspnet

About the Employer:
( 2 reviews ) Churchstoke, United Kingdom

Project ID: #18704076

Awarded to:

GenteelSystems

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 More

£27 GBP in 3 days
(2 Reviews)
0.3

17 freelancers are bidding on average £30 for this job

schoudhary1553

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

£50 GBP in 1 day
(153 Reviews)
7.5
VladimirLilenko

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

£20 GBP in 1 day
(137 Reviews)
6.4
SBITServices

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
(73 Reviews)
5.5
archanaoswal

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

£40 GBP in 1 day
(57 Reviews)
5.5
rayyankabir

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

£18 GBP in 1 day
(18 Reviews)
4.8
Ahmed818

Hello, i am interested in this project , can begin now waiting your answer on chat Regards

£18 GBP in 1 day
(22 Reviews)
3.9
KozlouAlex

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

£31 GBP in 1 day
(6 Reviews)
3.3
WaseemSh

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

£30 GBP in 1 day
(3 Reviews)
2.8
pnjadhav

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

£111 GBP in 1 day
(3 Reviews)
2.4
kipdev13

Hello sir. I read your description. I have enough talents and skills of this part. I can satisfy you. please contact to me.

£23 GBP in 1 day
(1 Review)
1.8
estebansalpeter

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

£13 GBP in 1 day
(1 Review)
1.0
ludwig333

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

£20 GBP in 1 day
(0 Reviews)
0.0
gpnr2017

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 More

£15 GBP in 1 day
(1 Review)
0.0
TalAkerele

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 More

£18 GBP in 1 day
(0 Reviews)
0.0
MedMESTIRI

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
(0 Reviews)
0.0
Luis315

Hi,I have read your description carefully and have full experience in this field. You will be satisfied about my working result if I have chance of completing your project. I have ability to help you using skill you More

£19 GBP in 1 day
(0 Reviews)
0.0