(Leo)Importing Data Error

L

Leo

Hi, Experts
I was trying to import an MS Access Query to my Excel sheet,(through
Importing Data Tool inside Excel) but the process failed by saying that it
doesnt know the NZ function (a function that I used in my query to remove
Null value).
How can it be fixed? and what does this have to do with my excel sheet?
 
B

BSPILLER

I tested your issue and I don't think there be a solution to the error.
Go for the Work-Around.
Use a different method of replacing the Null values ...
NewElement: IIf([Value] Is Null,"New Value",[Value])

or export directly from Access instead of importing from Excel.
 

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

Synchronization problems while moving folders to new email 1
Import External Data...Import Data... Error 0
Excel Import data error (ODBC) 0
Excel 2010 Table not showing in Access 2010 Import List 0
Import Excel 2010 table into Access 2010 - not listed as range 0
Import multiple Access Queries 0
Got a bug recently on a 36MB workbook with lots of hours in it. HE 1
Import external data 6

Top