Query to Access : does'nt see tables


V

Vuillermet Jacques

Office 2000 SP3 FR

From Excel / MS Query, I want to read data in Access tables.

I choose the mdb file and so MS Query displays this error message
(translated) :
"This data source does'nt have any visible table".

Original in French : "Cette source de données ne contient aucune table
visible."

I transfert my data to a new mdb file : it work's few times (!), then the
error message appears again.

How to resolve this problem ?

Jacques.
 
Ad

Advertisements

V

Vuillermet Jacques

Gotcha !

MS Query does'nt accept a file name with 2 dot inside !

Example :
MyFile.mdb --> Ok
My.File.mdb --> "This data source does'nt have any visible table"

!

Jacques.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Querying Excel tables from Microsoft Query 1
query links to SQL server and mdb table 1
Can't create a report from my query in Access 1
Adding a pivot table in Excel 2007 from a QUERY in Access 2007 6
using ado drivers with 64 bits software 1
Excel query of Access database - changed database filename, now error 2
Make Table Query in NEW ACCESS file 1
Delete query with joined tables 0

Top