Saving a CSV file in a memo field

C

CaribSoft

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.
 
A

Allen Browne

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
spreadsheet, 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.
 
C

CaribSoft

thanks ... great....
Allen Browne said:
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
spreadsheet, 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.
Click to expand...
 
Top