[AccessD] Recordset into Text File

---- London Borough of Bromley E-Mail Disclaimer ---- 
"For information about Bromley Council visit our web site
www.bromley.gov.uk" 

"The information contained in this message (including any attachments) is
confidential in that it is intended solely for the use of the recipient to
which it is addressed. If you are not the intended recipient, the use of the
information by disclosure, copying or distribution is prohibited and may be
unlawful." 
---- End of Disclaimer ---- 

Ok, will look at that Seth...thanks again.
RyanS

 -----Original Message-----
From: 	Seth Galitzer [mailto:sgsax at ksu.edu] 
Sent:	28 April 2003 15:33
To:	accessd
Subject:	RE: [AccessD] Recordset into Text File

---- London Borough of Bromley Security Notice ---- 
"Please treat all e-mail with caution. Only open attachments from trusted
business sources whose material you are sure is safe. Refer to the Council's
e-mail and internet users Code of Conduct for further guidance on the
correct use of the e-mail system."

---- End of Notice ----

Ryan,

Me again. :)  My opinion: drop the Import specification method, and use
direct File I/O to parse the file and import the data yourself. 
Basically, you do the reverse of what you just did for the export.  Open
the file for Input, read a line, parse out the field data, and insert it
into the destination table and fields.

I've got sample code for that in the same place you found the export
routine. :)

Seth

On Mon, 2003-04-28 at 09:17, Smethurst, Ryan wrote:

> Hi All,
>  
> I'm trying to import a text file into Access and am a bit stumped by what
is
> required for a 'Specification Name'.  
>  
> I've looked at the macro dropdown list for this and it was empty.  (?)
>  
> Can anyone tell me what is required?
>  
> TIA
> RyanS 
> ----

-- 
Seth Galitzer			sgsax at ksu.edu
Computing Specialist		http://puma.agron.ksu.edu/~sgsax
Dept. of Plant Pathology
Kansas State University

_______________________________________________
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/20030428/33e736e3/attachment-0001.html>