473,386 Members | 1,801 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

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

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
2 1591
zmbd
5,501 Expert Mod 4TB
@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
Mihail
759 512MB
Maybe this discussion also will help you.
May 31 '12 #3

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

Similar topics

6
by: Geert-Pieter Hof | last post by:
Hello, My VB 6.0 application read and writes data from and to a MS Excel workbook, using the Microsoft.Jet.OLEDB.4.0 provider. Now I want to protect the Excel workbook with a password, but I...
2
by: WZ | last post by:
I used the following code to create a workbook and save it in a webapplication. dim oExcel As Excel.ApplicationClass dim oBook As Excel.WorkbookClass dim obooks As Excel.Workbooks dim designb...
1
by: Jerry J | last post by:
I am sending Excel reports to web clients. Excel opens in internet explorer displaying multiple sheets. It is pretty simple to do and works well. To do it, a client clicks a link to an ASPX page...
1
by: david shapiro | last post by:
I've created an excel workbook with several worksheets. In each worksheet, I've highlighted a number of the cells containing key statistics in red. Is there any easy one-step way that I can pull...
1
by: dwmaillist | last post by:
Hello, I am interested in extracting the information from an excel workbook with many sheets in it and outputting a csv like text file. Since I want a single file with all information for all...
6
by: William Foster | last post by:
Good morning all, I want to password protect a Microsoft Excel Workbook containing all my reference tables for a program, so that I can place the workbook in a central location that is...
0
by: mandara | last post by:
hi i was not able to write a programs such that it retrives the data from the database through sql queries and get the output in Excel using perl.when i write multiple Queries i need to get all...
2
by: RAGHAVENDRAS | last post by:
Hi, I am writing a script which should update an excel sheet daily. So how do I determine which is the last row which contains data and then write the latest data into the sheet. use...
3
by: samj | last post by:
Looking at code examples, it would seem this is simple, but I can't figure it out. From an Access 2000 form command button, I want to copy all worksheets in an existing workbook to an existing...
10
by: afromanam | last post by:
Regards, Please help What I'm trying to do is this: (and I can't use reports since I must export to Excel) I export some queries to different tabs in an excel workbook I then loop through...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.