467,211 Members | 1,201 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,211 developers. It's quick & easy.

Exporting memo columns to separate files

How can I export a table such that data in memo columns is sent to
separate files, with placeholders in the main file?

Thanks,

Andy

Nov 13 '05 #1
  • viewed: 1304
Share:
2 Replies
Andy Asked

How can I export a table such that data in memo columns is sent to
separate files, with placeholders in the main file?

You would need to create a new table_/1, with the primary key of your
existing table and a filename field, parse the recordset to save each
memo field to a file using the open# and put statements, store the
fieldname of the file so created, then create a query that joins the
two tables and includes all fields from the original excep the memo and
the fieldname from the new table, then export the query.

_/1 or add the field to the table.

Q

Nov 13 '05 #2
Thanks - I've now found a way to handle my exported data as a single
file, but the problem now is that the memo columns contain carriage
returns, which is confusing the destination software. Is there some
(preferably simple) way I can convert these during the export?

Andy

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Janne Ruuttunen | last post: by
1 post views Thread by Jacky11 | last post: by
3 posts views Thread by premmehrotra@hotmail.com | last post: by
6 posts views Thread by Kevin Chambers | last post: by
2 posts views Thread by steph@landauconsulting.net | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.