conecting to Access Database with excel

O

Octet32

In Excel I am trying to connect to a Access database using the New Data Query
Wizard
When I get to the choose Columns screen and click on the Available table and
columns
I receive an error Undefined function ‘Date’ in expression.
(The database does have a function with this name that works correctly

I cannot Preview data in the columns if I then click on cancel
I receive a massage do you want to continue editing this Query in Microsoft
Query?
I select yes, the Add tables box opens I click on the table I want I
receive error cannot access table.

Anyone have any ideas how I can do this?
 
K

Klatuu

If your Access table has a field in it name Date, rename it. Date is an
Access reserved word and can cause this kind of behaviour.
 
O

Octet32

Its seem to not like any tables that has a function in, it i change the name
but it keeps coming up with the name of the fuction in the module as the error
 
O

Octet32

The Query is one of many that gives the total results
there are 2 function in the previous queries one that formats the Date, and
the other in a joining query one adds a day to the date.
They are both in a module .
 
K

Klatuu

Sorry, but queries are not in modules. Modules contain only VBA code. Now,
if what you are saying is you are trying to link to an Access query that has
functions in the query, particulary those that may have VBA code in them, it
isn't going to work.

I suggest you create your query in MS query directly against the Access
tables and use Excel to perform the functions Access is doing now.
 
O

Octet32

Yes that what is happening
thanks

Klatuu said:
Sorry, but queries are not in modules. Modules contain only VBA code. Now,
if what you are saying is you are trying to link to an Access query that has
functions in the query, particulary those that may have VBA code in them, it
isn't going to work.

I suggest you create your query in MS query directly against the Access
tables and use Excel to perform the functions Access is doing now.
Click to expand...
 

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
Format Funcyion in Access 2007 2
Help with VBScript/Access database 0
Access Error - The Microsoft Access database engine could not find the object 'Databases' 0
Importing Data from Excel when data not in same format 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Database name added to link tables! 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0

Top