Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    72

    Unanswered: share txt file as database

    assuming i have a txt file into a dir server here is the global dim:

    Global Const PATH = "\\GCD01F4500\DATI\PUBBLICA\INPS\CARTEL1.TXT"

    Is possible with a vba macro ,to make a vlooup into text file (like database) and sheet with the index in column A and retrive the result of match into column B

    In effect from each value into column A of sheet matching record into text file and return the result into column B of sheet...

    Note: into txt the first line is the header of record.

    ziped file: http://www.mytempdir.com/644325

  2. #2
    Join Date
    Feb 2006
    Posts
    113
    Possible, I guess so. Being a text file it won't be efficient, I think. As in, because it is a text file, you couldn't use database type matching functions, only text matching that would require looping through every record.

    Instead it might be better to open the text file and (temporarily) store the data in Excel whilst you do the lookups - either VLOOKUP, or INDEX/MATCH or via SQL or whatever.

    HTH,
    Fazza

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •