Matthew_H wrote:
Query fails to fetch Excel data formatted as currency. How can I get

currency data from Excel

First, ensure your data actually is of type Currency. Formatting is a
factor but no guarantee e.g. Text in a column with a currency format is
still Text. Ensure you do not have a mixed types situation - see:

http://www.dicks-blog.com/archives/2...ed-data-types/

Jamie.

--