[AccessD] TextTransfer

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



More information about the AccessD mailing list