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

Need help with merging spreadsheet together

P: n/a
I have five spread sheets from 1 to 2500 (rows), and i would like to
know how can i pull the remaining four spread sheet onto spread sheet #
1. it work with Cut and Paste, but that's too long, i would like to
know if it's an easier way. Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Have you posted this on an access group because you'd like to put this
spreadsheets into access?

If so try the import data (wizard) feature in access.

On the first import (ie your first sheet of data in the spreadsheet)
create your table. For the rest do the same but look out for the append
data option in the wizard.

One advantage of this method is that you can adjust the design of the
table (after the first import) to prevent/highlight duplicate, blank or
unexpected data types from importing.

Once you;ve done this you could always export out to excel again.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.