[AccessD] Copy and paste from clipboard

Instead of using the Docmd, why not just write the data using sequential 
access.  If you need a code example please let me know.  I have found it 
to work faster and easier instead of using the Docmd for exporting to text 
files.




"Mark Boyd" <MarkBoyd at McBeeAssociates.com>
Sent by: accessd-bounces at databaseadvisors.com
06/20/2003 04:03 PM
Please respond to accessd

 
        To:     AccessD at databaseadvisors.com
        cc: 
        Subject:        [AccessD] Copy and paste from clipboard


This may seem like a strange request, but I've been asked by my boss to 
check with this list.
 
She has a process that exports a 1-record table to a text file.  This text 
file is then imported into a client's billing system.
Currently, she is using 'DoCmd.TransferText, acExportDelim ?' to create 
the text file.  The problem comes about when the other system tries to 
read the text file.  It kicks back an error stating that it can't find the 
end-of-file.
 
Although, when she simply copies the text from the table, then pastes it 
into a text file, the client's system imports it without a problem.
 
Is there a way (in code) to copy the data from the table to the clipboard, 
then paste it from the clipboard to a text file?
I think I've seen this before, but am not sure.
 
TIA,
Mark Boyd
Sr. Systems Analyst
McBee Associates, Inc.
 _______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030620/4cb167ca/attachment-0001.html>