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

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

P: 20
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
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
PEB
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
Expert Mod 15k+
P: 31,487
This is a good answer Mukesh.
Let us know if you have any difficulties.
Dec 16 '06 #3

P: 20
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.