Search results

  1. S

    CSV mass import...with a twist (unforunately).

    The reason that all fields are not being pulled is becuase the person extracting the information is incompetent, and apparently this is the only way to pull it out of the current database. First, I thought that using a loop to insert the data record by record would work, but I feel that this...
  2. S

    CSV mass import...with a twist (unforunately).

    Hi Gemma. Thank you for the response! 1. I have 400ish folders named according to each individual customer. 2. Each folder contains data files named according to the table the data belongs to. 3. The field names for each data file are found in the first row in alphabetical order, BUT only...
  3. S

    CSV mass import...with a twist (unforunately).

    Hey folks, I have about 30 different master tables and there are about 100 individual data files that need to be inserted into each master. So far, I have created a macro in excel to list all of the possible field names in the data files, and I have dervived my my master tables from the...
Top Bottom