transfer multiple excel files to multiple tables in Access

[mit]

Hi,


I have 5 excel files and I need to transfer them into Access Database.I need a code to create 5 tables and transfer data in them.
(there should be one table for each excel file)
thanks

[ajetrumpet]

you should be able to use the below link to produce the code yourself: http://www.access-programmers.co.uk/...multiple+excel

[mit]

Thanks alot,it's exactly what I want.
in this code all the tables have numeric names from 0 to ....
I want them to ham my excel file's name.I should change the part of code.I found a function but I do not know how to change it.

for example,this is my full path=c:\myexcelfiles\file1.xls
I need the part of path like "file1".
can you help me please.

[ajetrumpet]

not sure HOW to, my friend.

you said you found a function, but that's it. how could I help you with just that?

[mit]

Thanks again,my problem has solved with the link you have posted