[AccessD] Recordset into Text File

I second that motion too...though I will admit, letting access import
automatically can be handy sometimes, you have far more control, and far
fewer quirks with using File I/O.

Drew

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


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