PCMech Forums - View Single Post - VB

Mcubed · 07-11-2000, 01:29 AM

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

------------------
Patience is the price you pay when you can't pay the price.

[This message has been edited by Mcubed (edited 07-11-2000).]

[This message has been edited by Mcubed (edited 07-11-2000).]

07-11-2000, 01:29 AM	#2
Mcubed Member (7 bit) Join Date: May 1999 Location: Albuquerque, NM USA Posts: 68	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 ------------------ Patience is the price you pay when you can't pay the price. [This message has been edited by Mcubed (edited 07-11-2000).] [This message has been edited by Mcubed (edited 07-11-2000).]