I
Incendius
Hello, I totally would appreciate any help in this matter... and I give you a warm thank you in advance!
This is what I need to do..
I have a 3rd-Party Program that exports data into an excel .xls file.
I know how to link that fine, I even have sorting queries and reports done off of that!
My problem is: The 3rd-Party Application basically has to overwrite the .xls file during export. I c an, however, specify a filename, as to avoid overwriting data. This is great if we are only working on one set of data at a time.
I had thought about just making duplicates of the work I have done 10 times and instruct the 3rd-Party app operators to just export to: export01.xls, export02.xls, etc.. and have copies of my queries, reports, etc configured to each linked table respectively. (so we can work with 10 sets of data) But I think that there would be a much easier solution.
ANY and ALL help in this matter would be greatly appreciated, as I am one a HUGE time constraint and have people to answer to! Ugh. Thanks again.
This is what I need to do..
I have a 3rd-Party Program that exports data into an excel .xls file.
I know how to link that fine, I even have sorting queries and reports done off of that!
My problem is: The 3rd-Party Application basically has to overwrite the .xls file during export. I c an, however, specify a filename, as to avoid overwriting data. This is great if we are only working on one set of data at a time.
I had thought about just making duplicates of the work I have done 10 times and instruct the 3rd-Party app operators to just export to: export01.xls, export02.xls, etc.. and have copies of my queries, reports, etc configured to each linked table respectively. (so we can work with 10 sets of data) But I think that there would be a much easier solution.
ANY and ALL help in this matter would be greatly appreciated, as I am one a HUGE time constraint and have people to answer to! Ugh. Thanks again.