Import Date from Access

M

Mr-Re Man

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?
 
D

Dave F

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
 
M

Mr-Re Man

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!
 
D

Dave F

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
 
Top