Importing Multiple Excel Files Into Access

[Orangeworker]

Hello,

I'm trying to import multiple Excel files into Access, but am getting:

Run-time error '3051':

The Microsoft Access database engine cannot open or write to
the file 'C:\Documents and Settings\H\Desktop\03-08-10'. It is
already opened exclusively by another user, or you need permission
to view and write its data

Any suggestions?

Thank you.

[Orangeworker]

THIS IS MY CODE

Please Login or Register  to view this content.

[bsaimsc]

I have tried this one but not executing, can you tell me, In this formula what is the meaning of "DoCmd.TransferSpreadsheet acImport, 8, "03-08-10", mypath & myfile". why you mentioned 8 in this sentence. please clarify me...

[protonLeah]

bsaimsc,
Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.