<br><font size=2 face="sans-serif">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.</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>"Mark Boyd" <MarkBoyd@McBeeAssociates.com></b></font>
<br><font size=1 face="sans-serif">Sent by: accessd-bounces@databaseadvisors.com</font>
<p><font size=1 face="sans-serif">06/20/2003 04:03 PM</font>
<br><font size=1 face="sans-serif">Please respond to accessd</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To: AccessD@databaseadvisors.com</font>
<br><font size=1 face="sans-serif"> cc: </font>
<br><font size=1 face="sans-serif"> Subject: [AccessD] Copy and paste from clipboard</font></table>
<br>
<br>
<br><font size=2 face="Tahoma">This may seem like a strange request, but I've been asked by my boss to check with this list.</font>
<br><font size=2 face="Tahoma"> </font>
<br><font size=2 face="Tahoma">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.</font>
<br><font size=2 face="Tahoma">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.</font>
<br><font size=2 face="Tahoma"> </font>
<br><font size=2 face="Tahoma">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.</font>
<br><font size=2 face="Tahoma"> </font>
<br><font size=2 face="Tahoma">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?</font>
<br><font size=2 face="Tahoma">I think I've seen this before, but am not sure.</font>
<br><font size=2 face="Tahoma"> </font>
<br><font size=2 face="Tahoma">TIA,</font>
<br><font size=2 face="Tahoma">Mark Boyd</font>
<br><font size=2 face="Tahoma">Sr. Systems Analyst</font>
<br><font size=2 face="Tahoma">McBee Associates, Inc.</font>
<br><font size=3 face="Times New Roman"> </font><font size=2 face="Courier New">_______________________________________________<br>
AccessD mailing list<br>
AccessD@databaseadvisors.com<br>
http://databaseadvisors.com/mailman/listinfo/accessd<br>
Website: http://www.databaseadvisors.com<br>
</font>
<br>
<br>