Add a blank row - DoCmd.TransferText

[Motion]

Hi all

I am using the DoCmd.TransferText command to export a query to a text file for the purpose of exporting invoice information from an access databse to an accounting programme.

Everything is working fine except that after every invoice number there needs to be blank row so the accounting software can differentiate between the various invoice numbers.

If you look at the examples i have attached, each exported row is an invoice item of which some invoices have many. After all invoice items are outputted for a particular invoice number a blank row needs to be inserted as in the file "Export Invoices Query (with space)". Unfortunately in this examples i manually inserted the space to show how it needs to look.

The file "Export Invoices Query" is how it is currently being exported.

I'm thinking that i might need to insert the space via the query but am not sure.

Any help here would be greatly appreciated.

Cheers!

Richard

 

[ajetrumpet]

Motion,

you could always add the blank row via the recordset method, either before or after creating a query in Visual Basic. This would only work though if there is no data that is required in a record, or there is no PK field in the table.

Other than that, I'm not too sure how you could do it...

 

[Motion]

Thanks for that, that's the answer i was looking for - and there are no pk's in the data.

Thanks!