Export as ascii and append to existing file

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
John,
Thanks! I'm going to give these options a try.
Appreciate the assistance.

Good days to you!
 
Back
Top