Access Queries Book Mark Error

G

Guest

I am trying to import data from a Navision Database. It allows me to connect
select the table then import. But when I go to veiw the information I
recieve alll Error's in the feilds. I also receive an error concerning a
Book mark.

I am able to query this database with Excel and all the inforamtion is
collected. I also can update the query with Microsot Query.

How can I pull this data into Access?

Also if I try to link to the Excel workbook it tells me to check if the file
exists or it is the right format.

I am using Office 2003.


Thank you
 
G

Guest

The data is already a .xls file. Access will not import the data, nor will
it link to it. The error is please check that the file exists and it is the
correct format.
I dont understand why this is rejecting this file.
Thanks
Christina
 

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

Access #Error & Excel Pivot 0
Navision & Access 1
query is not updatable;; urgent 1
Check box and make table query 1
Access update query 2
Access Overflow error 3
Query export as Table 2
Date and Parameter question. 4

Top