Re: Saving a CSV file in a memo field

From: CaribSoft (v)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 19:21:30 -0400

thanks ... great....
"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:4090837c$0$9409$5a62ac22@freenews.iinet.net.au...
> Although it is possible, I cannot imagine any scenario where that would be
> the best solution.
>
> The normal approach would be to link the Excel file so you can actually
get
> at the data (acts like an attached table) and work with it in either
> program.
>
> It would also be possible to use an OLE object to store the Excel file for
> each record of a table, allowing in-place activation.
>
> You have some serious work to do if you want Access the export of a text
> file (why text?) and then control Excel from Access to load the text as a
> spread***, present the user interface, let the user selectively manage
the
> export back to text, and then the reimport into the correct record again
in
> Access, regardless of whether the same (or multiple) Access session is
still
> in progress.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "CaribSoft" <v> wrote in message
> news:eRrk4gYLEHA.3324@TK2MSFTNGP10.phx.gbl...
> > I was asked by my if it was possible to save the contents of a csv or
the
> > csv file itself in a memo field of a record and programmatically load
that
> > file into an excel file on the fly, make some changes and then save the
> file
> > back to the record. Any ideas would be greatly appreciated.
>
>