spindar New member Local time Today, 09:02 Joined Jan 31, 2003 Messages 8 Feb 7, 2003 #1 Is it possible to export the data recovered from a query into Excel? I have managed to get the query to work properly but I can't figure out how to export it. Is this possible? Thanks for any help
Is it possible to export the data recovered from a query into Excel? I have managed to get the query to work properly but I can't figure out how to export it. Is this possible? Thanks for any help
Mile-O Back once again... Local time Today, 09:02 Joined Dec 10, 2002 Messages 11,316 Feb 7, 2003 #2 Look up the TransferSpreadsheet option in Macros.
spindar New member Local time Today, 09:02 Joined Jan 31, 2003 Messages 8 Feb 7, 2003 #3 Thankyou, I didn't realise that you could do it that way. The macro says what TABLE name to use so i thought it would only work with Tables. Thanks very much, my db has just taken a big step forward.
Thankyou, I didn't realise that you could do it that way. The macro says what TABLE name to use so i thought it would only work with Tables. Thanks very much, my db has just taken a big step forward.