[AccessD] Recordset into Text File

Seth Galitzer sgsax at ksu.edu
Mon Apr 28 09:33:26 CDT 2003


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



More information about the AccessD mailing list