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.

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/...php?t=envbadac

--
Regards,
Tom Ogilvy




"Tushar" wrote in message
om...
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.

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Tushar Garg wrote in message ...
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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


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.