Macro to Import Excel Data into an MS Access File

What is the Access File Name, Table Name in which data will be inserted and the Field Names of that Table?

It can be anything, what i want is that all the data which is in Excel file should be in Access file.

Download both attachments, zip file contains Access mdb.
Place both files in same directory.
Each time, previous data will be deleted from access file and
re-inserted from your excel sheet.

This is because the access table has just 5 fields in it. You will have to add new fields in that table.

ok, thanks for the information,
Is it possible to give it a file name by using another pop up.
I mean that instead of hard coding the file name in the code, the user should be asked for a file through a form, from where he can select a file.

Yes, get file name with this code, and use Filename variable to refer to access database:

Please Login or Register  to view this content.

ok, one more thing
lets say i had a input box where the user enters the name of the mdb file(in which the excel data will be copied).

I want to check that the file name which i had given in the input box, exists in my database or not.
As an example: I had a .mdb file Excel_to_Access in my database "Access_Converted" but when in input box i enter some other file name (say abc) then a pop up should come that "The specified file does not exist"

Please refer the attached sheet.

Please Login or Register  to view this content.

Thanks a lot, it helped
One more thing, I need to create another table of same structure with some different name.
I tried searching to create it by using
cn.execute "create table table_name as select * from Excel_to_Access"
but it is not working...
any suggestion for it?

Please Login or Register  to view this content.

Yippiee...
I cant believe this Hafiz sir, it worked!!!
Thanks a lot, you have really helped me...