Import Date from Access
 

I am trying to import data from Access but as I go through the process: Data,
Import External Data etc. it will display a few of the queries set-up but not
all of them, more importantly the one I need.

Anyone have any ideas?

Import Date from Access
 

I've had better luck accessing Access queries via Data--New Database Query.

Just select that, and via the dialog box, navigate to your Access db. In
theory you can use this tool to build a brand new query, however, you can
also access queries already in the Access db.

Post back if you have questions.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mr-Re Man" wrote:

I am trying to import data from Access but as I go through the process: Data,
Import External Data etc. it will display a few of the queries set-up but not
all of them, more importantly the one I need.

Anyone have any ideas?

Import Date from Access
 

Thanks Dave, I tried your method and it returned with a message "No visible
Tables", these tables are stored via sql, so they are no longer part of the
main database (they are there, but have a little globe next to them)

What I was led to believe, was that I could still access queries which are
left within the database, which I have been (I can see 5 queries) but there
are more than that in the database.

This is what I am doing to see the few queries in the database:

- 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.

I hope you can help, its driving me mad!

"Dave F" wrote:

I've had better luck accessing Access queries via Data--New Database Query.

Just select that, and via the dialog box, navigate to your Access db. In
theory you can use this tool to build a brand new query, however, you can
also access queries already in the Access db.

Post back if you have questions.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mr-Re Man" wrote:

I am trying to import data from Access but as I go through the process: Data,
Import External Data etc. it will display a few of the queries set-up but not
all of them, more importantly the one I need.

Anyone have any ideas?

Import Date from Access
 

Hi,

Unfortunately, I'm not an expert in Access. The problem you describe sounds
like it has to do with the way your database is configured. Perhaps posting
this problem in the Access discussion group will yield some insight.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mr-Re Man" wrote:

Thanks Dave, I tried your method and it returned with a message "No visible
Tables", these tables are stored via sql, so they are no longer part of the
main database (they are there, but have a little globe next to them)

What I was led to believe, was that I could still access queries which are
left within the database, which I have been (I can see 5 queries) but there
are more than that in the database.

This is what I am doing to see the few queries in the database:

- 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.

I hope you can help, its driving me mad!

"Dave F" wrote:

I've had better luck accessing Access queries via Data--New Database Query.

Just select that, and via the dialog box, navigate to your Access db. In
theory you can use this tool to build a brand new query, however, you can
also access queries already in the Access db.

Post back if you have questions.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mr-Re Man" wrote:

I am trying to import data from Access but as I go through the process: Data,
Import External Data etc. it will display a few of the queries set-up but not
all of them, more importantly the one I need.

Anyone have any ideas?