468,509 Members | 1,256 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,509 developers. It's quick & easy.

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

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 3092
PEB
1,418 Expert 1GB
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,097 Expert Mod 16PB
This is a good answer Mukesh.
Let us know if you have any difficulties.
Dec 16 '06 #3
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

Post your reply

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

Similar topics

3 posts views Thread by Duncan James | last post: by
2 posts views Thread by asad | last post: by
7 posts views Thread by Chuck Anderson | last post: by
reply views Thread by NPC403 | last post: by
3 posts views Thread by gieforce | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.