<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2652.35">
<TITLE>RE: [AccessD] Recordset into Text File</TITLE>
</HEAD>
<BODY>
<P><B><I><FONT SIZE=2>---- London Borough of Bromley E-Mail Disclaimer ----</FONT></I></B><I></I>
<BR><FONT SIZE=2>"For information about Bromley Council visit our web site www.bromley.gov.uk"</FONT>
</P>
<P><FONT SIZE=2>"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." </FONT></P>
<P><B><I><FONT SIZE=2>---- End of Disclaimer ---- </FONT></I></B>
</P>
<P><FONT SIZE=2>Ok, will look at that Seth...thanks again.</FONT>
<BR><FONT SIZE=2>RyanS</FONT>
</P>
<P><FONT SIZE=2> -----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Seth Galitzer [<A HREF="mailto:sgsax@ksu.edu">mailto:sgsax@ksu.edu</A>] </FONT>
<BR><FONT SIZE=2>Sent: 28 April 2003 15:33</FONT>
<BR><FONT SIZE=2>To: accessd</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] Recordset into Text File</FONT>
</P>
<P><FONT SIZE=2>---- London Borough of Bromley Security Notice ---- </FONT>
<BR><FONT SIZE=2>"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."</FONT></P>
<P><FONT SIZE=2>---- End of Notice ----</FONT>
</P>
<P><FONT SIZE=2>Ryan,</FONT>
</P>
<P><FONT SIZE=2>Me again. :) My opinion: drop the Import specification method, and use</FONT>
<BR><FONT SIZE=2>direct File I/O to parse the file and import the data yourself. </FONT>
<BR><FONT SIZE=2>Basically, you do the reverse of what you just did for the export. Open</FONT>
<BR><FONT SIZE=2>the file for Input, read a line, parse out the field data, and insert it</FONT>
<BR><FONT SIZE=2>into the destination table and fields.</FONT>
</P>
<P><FONT SIZE=2>I've got sample code for that in the same place you found the export</FONT>
<BR><FONT SIZE=2>routine. :)</FONT>
</P>
<P><FONT SIZE=2>Seth</FONT>
</P>
<P><FONT SIZE=2>On Mon, 2003-04-28 at 09:17, Smethurst, Ryan wrote:</FONT>
</P>
<P><FONT SIZE=2>> Hi All,</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I'm trying to import a text file into Access and am a bit stumped by what is</FONT>
<BR><FONT SIZE=2>> required for a 'Specification Name'. </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I've looked at the macro dropdown list for this and it was empty. (?)</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Can anyone tell me what is required?</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> TIA</FONT>
<BR><FONT SIZE=2>> RyanS </FONT>
<BR><FONT SIZE=2>> ----</FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Seth Galitzer sgsax@ksu.edu</FONT>
<BR><FONT SIZE=2>Computing Specialist <A HREF="http://puma.agron.ksu.edu/~sgsax" TARGET="_blank">http://puma.agron.ksu.edu/~sgsax</A></FONT>
<BR><FONT SIZE=2>Dept. of Plant Pathology</FONT>
<BR><FONT SIZE=2>Kansas State University</FONT>
</P>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>