ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem with notes query in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/91410-problem-notes-query-excel.html)

matpj

Problem with notes query in Excel
 

Hi all,

I have a spreadsheet with a query to a notes database using the Notes
SQL driver.
In MS Query this refreshes fine - and it used to refresh fine in Excel,
but recently I have been getting the error:

[Lotus][ODBC Lotus Notes]Data Value is not a valid date, time or
timestamp

can anyone suggest why this might be happening?

thanks,
Matt


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=547019



All times are GMT +1. The time now is 02:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com