By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,312 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

could not open the file for reading. close any other application that may be locking the file.

P: n/a
this error is a major pain in the bum. i have dealines to meet
requiring i import excel speadsheets into sql server. i have this one
spreadsheet and i cannot for love nor money import it into sql server!

i selected task manager to close any invisible instances of excel etc.
i rebooted twice, knocked out indexing service on may machine etc. etc.

then just for an experiment i removed the parenthesis from the
filename.... UK Brand Alias List (3 Dec 2004).xls

lo and behold it worked, nice to know there are some small bugs like
this in a flagship enterprise level microsoft product!
tristian2 of ewelme

Jul 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.