Recent content by Syllinger

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...

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...

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...