C
CW
We will be creating our sales invoices in my Access system, then I want to
export them as CSVs into our (UK) accounting system, Sage Line 50.
I have the import file specs from Sage and there are no probs with the data.
My question is how to create the process within Access?
There is an Invoices table with all the relevant data, and I will have a
flag that says whether or not an invoice has already been exported.
I guess I need a Query that will gather the data and filter it by that flag,
and how do I get it to compose it all into a CSV, and save it somewhere?
I'm sure lots of people have done this or something very similar before, so
I would be very grateful for your advice!
Thanks
CW
export them as CSVs into our (UK) accounting system, Sage Line 50.
I have the import file specs from Sage and there are no probs with the data.
My question is how to create the process within Access?
There is an Invoices table with all the relevant data, and I will have a
flag that says whether or not an invoice has already been exported.
I guess I need a Query that will gather the data and filter it by that flag,
and how do I get it to compose it all into a CSV, and save it somewhere?
I'm sure lots of people have done this or something very similar before, so
I would be very grateful for your advice!
Thanks
CW