want to automate excel import to access

[SKV]

I have loads of excel files to be uploaded in Access. Each file has the same field format and have 2 tabs (again with the same format)

I want to automate this import process such that while importing this data with all fields to one master table, it should capture the 3 more fields

1. Time it is uploaded
2. File Name
3. Tab Name

Can you please guide as how should I automate this process such that anytime some one drops a file in my folder, the file should automatically upload in my database or at most with one click.

Assuming all files have same file structure.

Thanks
Sachin

 

[SKV]

Anyone have any idea on this??? Please help

 

[SKV]

Please help, I am getting stuck

 

[SydneyGeek]

Do the two sheets in each book always have the same name?
And how do you want to deal with files that have already been imported?

Denis

 

[SKV]

Hi SydneyGeek,

I was waiting for you to look at this and I know you give a valuable feedback like always.

To answer your questions - the files are yest not imported. The files and tab may have different names in future. So to mitigate this complexity and refer back to the original file, I want that whenever a file named abc.xls with tabA and TabB and another file with named xyz.xls with TabX and TabY, ALL TABs have same file/field structure say fields c1, c2, c3 ....., then all the data from these files should be appended to a table in the following field structure that
File Name ; Tab Name; Date Import; C1 ; C2; C3........


I hope you got what I want. let me know if you need more clarification.

I look forward to hear from you.

Regards
SKV

Do the two sheets in each book always have the same name?
And how do you want to deal with files that have already been imported?

Denis