So here is the deal.
I am creating a database that will need to import about 5,000 csv files. I got that part down, the problem is where these files are located.
I'm downloading them off an internet server.
What I have done so fare is attached the link to a command button, but I must click the button 5,000 times for this process to work, basically every time I click the button, it changes the "hyperlinkaddress" property to the next address.
Is there a way in VB code to bypass the command button, basically what I’m looking to do, is click a button once, and have the files downloaded to a folder on my computer, then when that is complete, click another button and import each file into access, then kill them, I got everything done, except for the line of code that would say “hay download this file” Any help would be great. Thanks.
I am creating a database that will need to import about 5,000 csv files. I got that part down, the problem is where these files are located.
I'm downloading them off an internet server.
What I have done so fare is attached the link to a command button, but I must click the button 5,000 times for this process to work, basically every time I click the button, it changes the "hyperlinkaddress" property to the next address.
Is there a way in VB code to bypass the command button, basically what I’m looking to do, is click a button once, and have the files downloaded to a folder on my computer, then when that is complete, click another button and import each file into access, then kill them, I got everything done, except for the line of code that would say “hay download this file” Any help would be great. Thanks.
