John,
Thanks! I'm going to give these options a try.
Appreciate the assistance.
Good days to you!
--
Eva H. Linich
Business Applications
"John Nurick" wrote:
[Quoted Text] > 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.
>
>
>
> On Thu, 20 Jul 2006 04:35:02 -0700, Eva at Work <elinich[ at ]crescor.com>
> wrote:
>
> >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 [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.
>
|