I think I'll be fine this way, thank you again. I do have one question though. The code you provided before had me importing all the Fields on the report. If the report I want to use has 51 fields, which will remain constant, but I only want to import select ones... how could I modify the code? For example, the daily report I am pulling from has 51 fields, but I only need 19 of those fields. I could just import everything, but I have read how efficiency in these DB are key, so I figured it would be smart to limit to what I absolutely need.
Actually, I asked that question incorrectly. Each report has 2 fields, but has 51 rows of Data. If I only want specific rows of data, do I manipulate that with the "If recount>0" statement? Or is there a more efficient way to choose which lines of data to import.
Here are the two reports that have all the info I need, and are constant. Department totals, I just take everything. Gross Sales, I only need select data....
It depends on where the records are that you want, if they not at the beginning of the data you can set the recount> to where you want them to start.
ie
if recount>1 then
will start on line 2.
However if you wish to ignore later lines you will need an "If/then" for each line or batch of lines.
ie
if recount <> 3 and recount<> 4 and recount<>9 and recount<> 11 then
would skip those lines of code, you would then have to add an end if before the other end if for the recount>1.
However having complicated If then statements might actually sow down the import.
It might be better to leave it as is and just ignore or delete the data not required.
Gotcha... that makes sense. One more thought... if you look at the text files I sent, the data in the first column will be constant and actually probably should be fields in a table. Would it be better to import with the first column as the field and the second as the data for the table? That would eliminate half the data in the table each day. Also, if that was a better idea, how would I manipulate the code to import that instead?
That was basically how I think your table was setup, you then have to use if then statements to match the first column with the fieldname you want to put the value in.
ie
if varsplit(0) = "Beer then
![Beer] = varsplit(1)
end if