Bob Bedell
bobbedell15 at msn.com
Sat Oct 25 11:17:08 CDT 2003
Thanks guys. Appreciate the feedback and the link. Bob >From: Gustav Brock <gustav at cactus.dk> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >Subject: Re: [AccessD] TextTransfer >Date: Sat, 25 Oct 2003 17:19:54 +0200 > >Hi Bob > >As Stuart recommends, for text files go for basic file I/O. > >Here's a link to the site of Seth: > > http://puma.agron.ksu.edu/~sgsax/ > >Look for "My downloads", then "File I/O in VB": > > Code snippets demonstrating reading from > and writing to plain text files. > >It is not that difficult and it will save you a lot of trouble. > >You can use the same method for writing XML files as well but for >reading anything but extremely simple XML you'll need an XML parser. > >/gustav > > > > I just have a general question about all the available methods for > > transferring text using Access. I guess TransferText, the > > FileSystemObject, and the basic I/O methods (like Print#), are all valid > > options for this sort of thing, plus probably a few others I'm unaware > > of. My questions are, is there any reason to prefer one over the other, > > or is each best suited for a specific task, and what are the major > > differences, and what to people most frequently use, etc? I'm just > > talking about getting basic delimited text files (or maybe XML files) > > into and out of Access. Also, does the Import/Export wizard just create > > plain old vanilla schema.ini files for file specifications, and if so is > > there anyway to access those files from the file system, to modify them > > manually or move them, i.e., where are they stored, etc.? > > > Thanks for any thoughts, > > > Bob > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Enjoy MSN 8 patented spam control and more with MSN 8 Dial-up Internet Service. Try it FREE for one month! http://join.msn.com/?page=dept/dialup