M
Mr-Re Man
I have posted this question in the Excel forum, but had no luck and was
pointed in this direction.
What I was led to believe, was that I could access queries through excel
which are
are within the database, which I have been (I can see 5 queries) but there
are more queries in the database which I cannot see.
The process I am following to set up the import data (which lets me see just
5 queries is) :
- Data
- Import External Data
- Select Data Source (I am selecting database)
- Data Link Properties (I just click OK)
- Please enter MS JET OLE DB Initialization Info (I press OK)
- Then at the Select Table box, the 5 queries are stored here
- If I select any query and press OK
- It ask where I want to put the data in the worksheet
- Then it asks me for the SQL Server password
- Click OK
Records show
What I need to see is the recently created queries in the list.
FYI: the tables are stored in SQL on a server (they have a little globe next
to them)
it's the queries I need to access.
Any help would be appreciated, I'm tearing my hair out!
pointed in this direction.
What I was led to believe, was that I could access queries through excel
which are
are within the database, which I have been (I can see 5 queries) but there
are more queries in the database which I cannot see.
The process I am following to set up the import data (which lets me see just
5 queries is) :
- Data
- Import External Data
- Select Data Source (I am selecting database)
- Data Link Properties (I just click OK)
- Please enter MS JET OLE DB Initialization Info (I press OK)
- Then at the Select Table box, the 5 queries are stored here
- If I select any query and press OK
- It ask where I want to put the data in the worksheet
- Then it asks me for the SQL Server password
- Click OK
Records show
What I need to see is the recently created queries in the list.
FYI: the tables are stored in SQL on a server (they have a little globe next
to them)
it's the queries I need to access.
Any help would be appreciated, I'm tearing my hair out!