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

[mukeshsrivastav]

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.

[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!

[NeoPa]

This is a good answer Mukesh.
Let us know if you have any difficulties.

[mukeshsrivastav]

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.