• koyyatrouser (5/26/2014)


    Hi ..

    I have tried the code. But the whichfile column doesnt populate the file name. Its showing access denied.

    Can you please help ?

    Access denied is typically because the account in the servicesndoesnt have access.... examples are when you put files in c:\users\specificperson\desktop or my documents and the account cannot access. Move the files to a non private directory would fix it.

    If the account does have access then itnmight be because thenfile is open in excel at the same time this process isntrying to open it as well.

    If you give the exact error and path to files we could help further.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!