Data base edit within Excel (2000 user)

[pgarcia]

Hello all,
I'm Excel 2007 and am trying to link a DB. In Excel 2000 when linking the DB
it would ask you if you wanted to edit the query in Microsoft Query, how do
you get there now? I can find it.
Thanks

 

[boblarson]

1. Select a cell in the data area

2. click on the Data tab and then

3. Click on the EXISTING CONNECTIONS button on the GET EXTERNAL DATA GROUP

4. Select the Connection in this workbook

5. Right-click on the appropriate connection and select EDIT CONNECTION
PROPERTIES.

That should do it.
--
Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[MikeJohnB]

The answer below was googled, hope this helps???

1. In the Data ribbon, select From Other Sources>From Microsoft Query. The
Choose Data source window opens.

 

[pgarcia]

It's grayed out.

1. Select a cell in the data area

2. click on the Data tab and then

3. Click on the EXISTING CONNECTIONS button on the GET EXTERNAL DATA GROUP

4. Select the Connection in this workbook

5. Right-click on the appropriate connection and select EDIT CONNECTION
PROPERTIES.

That should do it.
--
Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________