Assuming that your text file only SSNs and that there's a field name as the
first row, you'd use something like:
DoCmd.TransferText acLinkDelim, , "MyTable", "C:\Folder\File.txt", True
You'd now have a "table" MyTable that points to the text file, and you can
use MyTable the same as any other table.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"JonWayn" <JonWayn[ at ]discussions.microsoft.com> wrote in message
news:4CB47D92-7B52-4605-B744-34AFFCBDF113[ at ]microsoft.com...
[Quoted Text] > How do you do that? > > "Douglas J. Steele" wrote: > >> You can use the TransferText method to link to the text file, and you can >> then treat that linked table the same as any other table other than the >> fact >> that it won't be updatable. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele>> (no private e-mails, please) >> >> >> "Matt" <mholland[ at ]fidm.com> wrote in message >> news:%23mXVIXJXJHA.4280[ at ]TK2MSFTNGP02.phx.gbl... >> > hi all, >> > >> > brand new to this forum..! hoping someone can help me - I use an >> > application developed in MS Access that permits users to use an ASCII >> > file >> > containing index info (SSNs) for specific records in the database in >> > order >> > to perform some action on each of those records in the database. Can >> > someone tell me what this functionity is referred to within MS Access? >> > As >> > a novice VBA developer, I am interested in duplicating this >> > functionality >> > in my own programs but can't discover what it's name is w/in the help >> > guide(s). >> > Thanks...!! >> > >> >> >>
|