MS Access 2002, Select...INTO...Excel?

  • Thread starter Thread starter circuit_breaker
  • Start date Start date
C

circuit_breaker

Hi,

Believe it or not, we're still using MsAccess 2002 here. Anyways, we
use it in order to query a SQL Server DB via an ODBC bridge. We run
our queries and then export the results to Excel for another group.

Question: I'd like to know if the query itself could export the
results directly to excel (or any other format) on my local
filesystem. I've seen some examples on the web (which applies to
Access 2007) but that doesn't work with 2002:

http://msdn.microsoft.com/en-us/library/bb177907.aspx

Thanks in advance.
 
Found the answer:

SELECT whatever
INTO
[Excel 8.0;Database=C:\SpreadSheet.xls].[Sheet001]
FROM
TableX
WHERE...
 
Back
Top