 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / May 2008conecting to Access Database with excel
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.  SignatureDave Hargis, Microsoft Access MVP > In Excel I am trying to connect to a Access database using the New Data Query > Wizard [quoted text clipped - 10 lines] > > Anyone have any ideas how I can do this? 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 > 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. [quoted text clipped - 13 lines] > > > > Anyone have any ideas how I can do this? Tables don't have functions in them, but Queries can. Can you tell me a bit more? SignatureDave Hargis, Microsoft Access MVP > 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 [quoted text clipped - 16 lines] > > > > > > Anyone have any ideas how I can do this? 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 . > Tables don't have functions in them, but Queries can. Can you tell me a bit > more? [quoted text clipped - 19 lines] > > > > > > > > Anyone have any ideas how I can do this? 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. SignatureDave Hargis, Microsoft Access MVP > 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 [quoted text clipped - 24 lines] > > > > > > > > > > Anyone have any ideas how I can do this? Yes that what is happening thanks > 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 [quoted text clipped - 32 lines] > > > > > > > > > > > > Anyone have any ideas how I can do this? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.