I'm attempting to automate a process at my job where we import data into an Access Database, run a series of queries to modify the data, then export the modified data. What I'm attempting to do is ...
How can I take a cvs file and basically plop it into an Access database via vbscript? I have a script that generates more than 65K lines of text, therefor Excel complains that it cannot open it.