[AccessD] Losing order when importing text

Export from a query.  Access doesn't really care about record order so
you get the natural (i.e., entry order) of the records when you export
the table, not the indexed order that they appear in when you look at
the table in Access.
 
Charlotte Foust

	-----Original Message-----
	From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com] 
	Sent: Tuesday, June 24, 2003 10:41 AM
	To: AccessD at databaseadvisors.com
	Subject: [AccessD] Losing order when importing text
	
	

	When I import text using Docmd.TransferText, my records import
out of order.

	It is very important that the records import in the exact same
order that they appear in the file.

	Is there a way to control this so the table keeps the text
file's exact layout?

	I am using AccessXP.

	 

	Thanks,

	Mark Boyd

	Sr. Systems Analyst

	McBee Associates, Inc.

	 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030624/018d8c79/attachment-0001.html>