Hi Leema, > Can any one help me how to go when file/dir/Sheet name > contain spaces in between???
Try this: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""C:\My Excel.xls"";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""" Note the doubling up of the double quotes. Regards, Shawn K. Hall http://12PointDesign.com/ http://ReliableAnswers.com/ '// ======================================================== "The great question that has never been answered and which I have not been able to answer....is, 'What does a women want?'" -- Sigmund Freud --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
