austdate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone,

I'm trying to import data from access to excel. i got a query with a
parameter and i have tried to put in the command parameter function in. but
strangely i'm getting an error saying "undefined function 'AustDate' in
expression.

can any1 please help me why is this error coming up.

Regards Prashant
 
Are you importig from an Access Query? Look at the SQL view of the Query.
Within the Access interface, it is possible to use any user defined function
but any SQL that uses such functions fail when using an ODBC deliver or OLEDB
provider.

I am guessing but AustDate seems like a UDF: I would guess that it
transforms dates into the Australian date format. If so, you could circumvent
the need for it by:

1. Within Access, write the Query to a Table and from your application(
SQL), read the table instead.
2. Set your data format in regional setting to the Australian format, read
your data and then reset your regional setting.

Ajay
 
You must log in or register to reply here.

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
index function in vba 3
Null To Zero - ODBC Error - Undefined function 'Nz' in Expression 3
Run Query w/Function from Excel 1
Invalid function importing data query from Access 1
Access Invalid bracketing of parameter name 1
Excel 2007 data query parameter issue 6
Run Query w/Function from Excel 3

Back
Top