Create macro to download access 2000 table to excel 2000 spreadsheet

[Tushar]

Hello,

I am trying to import a table from access 2000 to excel 2000. The
table name is 'Download Table' and the excel spreadsheet is 'CERCLIS'.
I need to make it a macro. Could someone please show me the code I
need to make this happen. Thanks in advance.

 

[Tom Ogilvy]

On way would be to go to the Data menu and select Get External Data.

another way would be to use ADO

See Mr. Erlandsen's site for sample code for ADO and DAO:

http://www.erlandsendata.no/english/index.php?t=envbadac

 

[Tushar Garg]

Thanks for all the help Tom. If I have any more questions, is there a
direct e-mail I may reach you at? Thanks again

 

[Tushar]

Thanks for all the help Tom. If I have any more questions, is there a
direct e-mail I may reach you at? Thanks again

Tom,

I have another one for you. The project i am working on, divides a
year into 4 quarters. Example, 10/21/2004 is marked as 20044 (Year/Q)
in the access database. If the user puts in any year with the
respective quarter, the download needs to be from that point on till
the last record. I got the table to download using your original idea
of Data->Get external data. If you can show me how to filter down
data based on this Year/Q constraint, that would greatly appreciated.