I have the following code that I cobbled together from various recordings of data imports and queries. Can someone help me with the syntax? The problem seems to be in my WHERE statment. I get a "Run-time error '1004': Data type mismatch in criteria expression."
** Edit**
Please Login or Register to view this content.
Wow. I change the path of the source to ActiveWorkBook.Path instead of a fixed path, and it asks me to "Please enter MS Jet OLE DB Initialization Information".
Last edited by Whizbang; 12-04-2009 at 12:44 PM.
You might try
I was also a little suprised to see 'Date Call Placed' with spaces and not underscores?Please Login or Register to view this content.
Martin
The 'Date Call Placed' is in single quotes, so no underscores needed.
I figured out the where statement (I think. This project was a while ago.). I needed to format the ranges as yyyy-mm-dd hh:mm:ss.
P.S. I would mark this thread as solved, but I can't seem to edit the original post. Probably because it is so old.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks