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
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
you should be able to use the below link to produce the code yourself: http://www.access-programmers.co.uk/...multiple+excel
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.
not sure HOW to, my friend.
you said you found a function, but that's it. how could I help you with just that?
Thanks again,my problem has solved with the link you have posted