Exporting the results of a SQL statement to excel

M

Mac

Dear all,

I'm trying to create a report that whn closing asks the user if they
wish to create an Excel file based on the report data for future
import into my database, (the data for reason to boring and endless to
go into has to get external approval before being added hence the
report and the export/import routine). I have my sql statement and
have gotten as far:
SQL01= "SELECT etc.......".
Docmd.runsql

My question is where to go from here, should docmd.runsql be
docmd.transferspreadsheet (in which case how do I reference my SQL
statement) or is there something else I need to do first ?

TIA

Andy
 
T

Todos Menos [MSFT]

you should not use Excel for anything.

Excel is a dangerous format for data entry; because it does not
support true data types.

-Todos
 
T

Tony Toews [MVP]

Todos Menos is not a Microsoft employee. This posting is by A a r o n
K e m p f.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
T

Todos Menos [MSFT]

Tony;

I never claimed to be a Microsoft Employee

go and play with yourself, RENOB
 
T

Todos Menos [MSFT]

Warning Warning!

Tony is NOT a microsoft employee
this posting is by t o n y t o e w s
 
Top