G
Guest
Ok, I'm def not an expert to Access. We do auto exports of data results from
a query into text files right now. For some reason the vendor in charge of
the picking up the text files can't get them to load on their 2003 server, he
thinks there's problems with the text driver. Anyway I need to create a
macro that I can run as a scheduled task, similar to the initial runs, but
instead of exporting text files, I want to export the query results into a
table. I know this sounds simple but I can't get it to work. I did try
exporting to an .xls file and importing it, but it keeps prompting me to
overwrite the .xls file everytime and I want this to be able to run without
user input, any suggestions, thanks in advance.
a query into text files right now. For some reason the vendor in charge of
the picking up the text files can't get them to load on their 2003 server, he
thinks there's problems with the text driver. Anyway I need to create a
macro that I can run as a scheduled task, similar to the initial runs, but
instead of exporting text files, I want to export the query results into a
table. I know this sounds simple but I can't get it to work. I did try
exporting to an .xls file and importing it, but it keeps prompting me to
overwrite the .xls file everytime and I want this to be able to run without
user input, any suggestions, thanks in advance.