Export as ascii and append to existing file

[Guest]

I have an ascii file (slsinv.asc) updated daily through my ERP system which
captures invoicing information. I have a DB that contains archived invoicing
information.

I want to APPEND the archived data into the existing slsinv.asc file. I need
the data to be COMBINED since the slsinv file is part of an OLAP cube.

Is it POSSIBLE to APPEND an ascii file to another ascii file?
Or will I have to take the slsinv.asc and combine it with the archived data
and THEN feed it to my cube?

 

[John Nurick]

Hi Eva,

Access's standard text export system cannot append new data to an
existing text file. The alternatives include:

1) export the new data to a new file and concatenate this to the
existing one, e.g.
Shell "COPY slsinv.asc + newfile.asc slsinv.asc"

2) export both new and existing data to a new file.

3) write a procedure that uses VBA file I/O (e.g. the Open, Print and
Close statements) to append the new lines to the existing file.

 

[Guest]

John,
Thanks! I'm going to give these options a try.
Appreciate the assistance.

Good days to you!