By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

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

P: 1
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.
May 29 '12 #1
Share this Question
Share on Google+
2 Replies


zmbd
Expert Mod 5K+
P: 5,397
@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/answer...to-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
May 29 '12 #2

100+
P: 759
Maybe this discussion also will help you.
May 31 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.