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

"Prashant Gupta" wrote:

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