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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 <(E-Mail Removed)> wrote in message news:<(E-Mail Removed)>...
> 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.