Hi Everyone,
I'm new here and this is my first post. I believe the answer is simple if I knew where to look.
I am exporting a query containing line items and one of the fields in each line is an invoice ID. The problem is the financial app that imports this file is expecting a blank line every time the Invoice ID changes.
When I export the file and manually insert the blank lines in excel the import works fine. I even made a macro in excel that automates this but of course the file gets recreated each export and so overwrites it.
I have tried exporting in CSV, txt and xls it really doesn't matter but the importing app is expecting txt or csv.
My users will be using a Access 2007 runtime and Excel 2003