Exporting data

[Chris]

I want to export data from a record to a delimited text file - no problem.
However, I want to add exported records to that text file and append them to
the end. At the end of the day the records will be imported sequentially
into another program in the order they were added to the export file.

Could anyone tell me how I can append data to an existing export file?

Any help would be appreciated

Chris

 

[Les]

Not sure if this will help, but could you append each
record into an access table, then, at the end of the day,
export the entire table as delimited text file? They
would be in sequential order.

 

[Chris]

Sounds like a good suggestion and quite easy to achieve.

However, I need to import into an accounts program several times a day or
whenever the user requires using the accounts program to generate invoices
based on the access data.

I suppose the trigger on the accounts side could export the access data and
then import it from the table though.

I found code which states that it will append to a text file but I can't
make head nor tail out of it as I'm not really a programmer as such. Here's
the link to it if you're interested in following this up.

http://www.mvps.org/access/modules/mdl0058.htm

if you have any further ideas based around this it would be interesting to
hear from you

Thanks again for the suggestion

Chris