Access to Excel
 

I have run an Access query, giving me 1000 rows and 10 columns of data.

Starting from an Excel blank sheet, I would like to:

1. Paste the Access query result into cell A1 as text

2. Place the SQL code for the active Access query in a text box or comment
box

Thanks for any help on this.

regards
Daniel

Access to Excel
 

First you need to set up an ODBC Data Source using your ODBC Administrator in
the Administrator Tool in your Control Pannel.
Once you setting up pointing to your access database, you can query your
data using the Data Menu from the Main toolbar:

Data-Import External Data-New Database Query

And you will get a dialog box where you select the Database connection you
just setup using the ODBC Administrator, and just follow the on-screen
directions.

Michael,

Please rate this posting if it was useful.


"Daniel Bonallack" wrote:

I have run an Access query, giving me 1000 rows and 10 columns of data.

Starting from an Excel blank sheet, I would like to:

1. Paste the Access query result into cell A1 as text

2. Place the SQL code for the active Access query in a text box or comment
box

Thanks for any help on this.

regards
Daniel

Access to Excel
 

Hi Michael - thanks for the reply, but I don't think this is what I want. I
would like physically copy the data that has already been run in Access (we
have our reasons for this), and bring it back into Excel


"Michael" wrote:

First you need to set up an ODBC Data Source using your ODBC Administrator in
the Administrator Tool in your Control Pannel.
Once you setting up pointing to your access database, you can query your
data using the Data Menu from the Main toolbar:

Data-Import External Data-New Database Query

And you will get a dialog box where you select the Database connection you
just setup using the ODBC Administrator, and just follow the on-screen
directions.

Michael,

Please rate this posting if it was useful.


"Daniel Bonallack" wrote:

I have run an Access query, giving me 1000 rows and 10 columns of data.

Starting from an Excel blank sheet, I would like to:

1. Paste the Access query result into cell A1 as text

2. Place the SQL code for the active Access query in a text box or comment
box

Thanks for any help on this.

regards
Daniel