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.


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.



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:


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)

17 freelancers are bidding on average £30 for this job


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)

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on 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)

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)

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)

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)

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

£18 GBP in 1 day
(22 Reviews)

Hello. Below is recent Access project completed by me: I suggest to create dedicated query for entire task then when this tab More

£31 GBP in 1 day
(6 Reviews)

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)

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)

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)

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)

Hi. i am a full web developer with over 5 years on ****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)

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)

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)

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)

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)