drmichaelw
IS-IT--Management
I am running Access 2000. I have created a link to an external excel file and I am running a number of queries on this link.
I am trying to export the results of one of those queries back to the same excel file. I created a macro to do this in the macro in the macro window.
I am exporting however the results a jumbled. It seems that a new worksheet is created in the excel file, however there is data in this worksheet from other parts of the excel file as well as from the query I am exporting.
Can I export to an excel file that I am linking to?
I have exported to other excel files in the past, however I was not linking to this table.
I am trying to export the results of one of those queries back to the same excel file. I created a macro to do this in the macro in the macro window.
I am exporting however the results a jumbled. It seems that a new worksheet is created in the excel file, however there is data in this worksheet from other parts of the excel file as well as from the query I am exporting.
Can I export to an excel file that I am linking to?
I have exported to other excel files in the past, however I was not linking to this table.