conecting to Access Database with excel

  • Thread starter Thread starter Octet32
  • Start date Start date
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?
 
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.
 
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
 
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 .
 
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.
 
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...
 
Back
Top