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

Combining sheets in Access

P: n/a
I've imported a very large Excel file into Access and because it needed
to be slightly reformatted in Excel I had to split it into three
separate sheets first. I then imported the sheets separately into
Access - how do I now re-combine the three into one big table?

Oct 20 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
The safest route is
create a 4th table with the proper definitions (copy of one of the
existing 3)
Write an Append query for each of the two remaining tables into this
new table.

That way if something is wrong you can always do it over again.

Ron

Oct 20 '06 #2

P: n/a
On 20 Oct 2006 04:24:51 -0700, fi***********@googlemail.com wrote:
>I've imported a very large Excel file into Access and because it needed
to be slightly reformatted in Excel I had to split it into three
separate sheets first. I then imported the sheets separately into
Access - how do I now re-combine the three into one big table?
Were the sheets split vertically or horizontally?
Oct 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.