473,581 Members | 3,046 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

importing data form multiple excel files(same fields and forma in one access database

20 New Member
dear sir

i want to move form excel to access.
i have 5 excel file having same formats and fields.now i want to import all data in one access table.
importing one file is easy .but importing and appending second file in last of the access table created earlier by importing data.


thanks .plz help me.
Dec 16 '06 #1
3 3343
PEB
1,418 Recognized Expert Top Contributor
Hi

As it isn't repetitive process and u will do this importing only once, so i suggest to do it at the most semple way that is possible!

So:

U arrange your columns in Excel as it is in Access

Than u select ur Excel first Sheet,

U choose Copy from Edit

And finnally u go to the Access table and u slect Paste Append /NB Paste Append not only Paste/

And ur data is tranfered

U repeat the same to the others sheets from Excel and u're ready to go with Access

Best regards!
Dec 16 '06 #2
NeoPa
32,566 Recognized Expert Moderator MVP
This is a good answer Mukesh.
Let us know if you have any difficulties.
Dec 16 '06 #3
mukeshsrivastav
20 New Member
Hi

As it isn't repetitive process and u will do this importing only once, so i suggest to do it at the most semple way that is possible!

So:

U arrange your columns in Excel as it is in Access

Than u select ur Excel first Sheet,

U choose Copy from Edit

And finnally u go to the Access table and u slect Paste Append /NB Paste Append not only Paste/

And ur data is tranfered

U repeat the same to the others sheets from Excel and u're ready to go with Access

Best regards!

Thanks you very much!
Its my pleasure to get response and be connected with all of you.
Dec 18 '06 #4

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

Similar topics

3
3460
by: tesc | last post by:
I am so aggravated and need any help I can get. I am using Access 2000 and am trying to sort multiple fields in a select query. My query is set up as follows: FIELD 1 FIELD 2 FIELD 3 FIELD4 FIELD 5 FIELD 6 MSA03 MSA 02 % change ICU 03 ICU 02 % change calc. calc. This format continues and in...
3
1636
by: Duncan James | last post by:
Hi Where to begin? Well, we have been using index sequential files in cobol and would like to move away from them to relational databases. Where is the best place to start? We want to be able to read single and multiple records, write, delete and update records. We want to be able to read the data into entry boxes on forms so it can...
2
2376
by: asad | last post by:
hello, how ru all pls tell me how can i create DAL and how can i use it in my ASP.NET pages thanks
7
3799
by: Chuck Anderson | last post by:
I'm pretty much a JavaScript novice. I'm good at learning by example and changing those examples to suit my needs. That said .... ..... I have some select fields in a form I created for a database search that I am unable to figure out how to access. (The search is implemented in Php/MySQL.) The user enters search values for: name,...
3
2902
by: SAL | last post by:
Hi, I have Microsoft Enterprise Library 2005 installed on my local system. I'm developing in C# using Visual Studio 2003 IDE with framework 1.1. I am automating a process that will use a DLL assembly I am developing. I am going to use the data Access Application Block for data access in my DLL assembly, and a Windows Service will execute...
5
6400
by: rewalk | last post by:
Hello all, I've set up protected Excel sheets that users can paste data into. I then need to be able to pull the data they paste into multiple access tables and then reset the Excel spreadsheet back to the template. For example, the first few columns go to the first table, the next 3 into a second table and so on. Is this possible? I can't...
2
1442
Curben
by: Curben | last post by:
Hello all, I am back with the new project i have had thrown at me. I need to make a DB with forms that are accessible by multiple countries on our network so this will not be "web based" per se. I am using access 2003 with an access 2000 format. I tried to make a data access page but once i save the page i get connection errors. The form...
4
3348
by: forrestgump | last post by:
I want to be able to export multiple access query results to 1 excel worksheet so the results appear under each other. I need this to show the results of headcount, leavers and starters in a cost centre. I do not want to have to run 3 separate reports on 3 different tabs. I want them all on 1 tab and under each other. I can run vba to pull...
2
1550
by: ggarz1 | last post by:
I am currently creating a database for a new company that we acquired. There are a small number of private sales reps based out of their homes. Initially, these people were sending in files/order forms(mostly excel files) of their sales that need to be entered in one database. With all of these reps providing bad data without constraints,...
2
2156
by: Riak | last post by:
Hellow Helpers: I am doing data entry job manually and data is huge. Now I was told to write/get some sort of program/script which can do this job quickly, otherwise I will loose job. I am good computer user but far away from programming, however I can make minor/little changes into script/program e.g. if it reads one records, I can update...
0
7886
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7809
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8159
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7920
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6569
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3809
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3835
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2312
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1413
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.