rmechaber (7/22/2011)
SwePeso (7/22/2011)
Use IMEX=1 in your extended properties for the driver.Thanks, but that's not the issue here.
The same query on the same Excel file works fine immediately after (and for some varying time after) a service restart.
Likewise, though I didn't include this in my o.p., the issue some have written about re: NTFS permissions in the user temp folder is not germane. I can run the same query on the same spreadsheet without problem after a service restart. So NTFS permissions aren't in play.
Anyone else have an idea?
Rich
I used to get that pretty often using Jet 4.0, and the only solution anyone ever had was to cycle the service. Recently switched to Ace, and hoping I don't also run into the other error now too. That was half the reason I switched.