Well supposidly i cant enter the directory path within the SQL statement field, as the dir-link has been established within one of the other fields (cant remember off hand) but the path was correct and using the "test connection" button whilst in design mode -
VB found the file and connection was "successful"
*shrug*
anyhow thanks
quote:
Originally posted by Mcubed:
I apologize for sounding trite, but have you checked to insure that you've placed a correct directory reference in the SQL statement? As you probably know, the slightest typo can do you in there.
Another thing, if the Excel sheet has several pages, you may have to specify which page. I don't know for sure about that one, but I've run into it when grabbing data from Excel from inside Word and other office programs.
Hope this helps
MMM