how to append the data from excel workbook containing several sheets into an access d

[BaseData]

Hello All,
I have several excel workbooks coming in every week. I am able to do the manipulation over these excel workbooks and get single workbook containing several sheets with same name every week. Now I have to transfer these data in already existing database in already existing respective tables. Could you guys help me making it possible.

[zmbd]

@BaseData
Ok, what I understand is that you have a ton of data coming into you in some sort of unformated, uncontrolled, worksheet that you then have to manually kull and then you get something that you can work with... is that correct?

If so, then I suggest that you start by reading the following thread... the link contained therein and the warnings given by NeoPa and others in both the following and the linked to thread!

http://bytes.com/topic/access/answers/940200-after-exporting-access-query-xls-how-do-i-use-vb-auto-rename-file

A better method may be to have the database available in some manner such as thru sharepoint or a web-based application either would allow you to apply better control to how the data is imported and would allow the people sending you data to enter it themselves with a tad of help from the GUI.

-z

[Mihail]

Maybe this discussion also will help you.