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

Silly problem on queing

P: n/a
Dear SQL MS-Access Programmers,

can You help me?

I must append a table in MS-Access 2000 to another,
because the new table has new data with same formats
imported from an excel file, that must be added to an older table.

I know that the operation due is named "queing query" (translating from
italian formally)
but I don't find the right instruction to do so everywhere.

Because I am sure that SQL commands can be used to do so,
can someone suggest the right operations in MS-Access2000 windows?
Or the right SQL scripts of commands?
Or where I can find some references about this silly operation?

Sorry, but I did the same with APPEND command in SAS or SPSS packages
many times, ten years ago, without any problem.
I had all reference book needed.
Now instructions are so difficult to find and I don't understand
the ratio of this unavailability.

Many thanks

Alberto
May 20 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Suspect you just need an Append Query.

Easiest way is to create a new Select Query (using the New Query wizard
based on the new table imported from Excel) and in Design Mode to to
Query ->AppendQuery then select the original table to append to.

Hope this helps

Phil
"Alberto A. Villa" <aa*****@quantum-services.itwrote in message
news:46***********************@reader1.news.tin.it ...
Dear SQL MS-Access Programmers,

can You help me?

I must append a table in MS-Access 2000 to another,
because the new table has new data with same formats
imported from an excel file, that must be added to an older table.

I know that the operation due is named "queing query" (translating from
italian formally)
but I don't find the right instruction to do so everywhere.

Because I am sure that SQL commands can be used to do so,
can someone suggest the right operations in MS-Access2000 windows?
Or the right SQL scripts of commands?
Or where I can find some references about this silly operation?

Sorry, but I did the same with APPEND command in SAS or SPSS packages
many times, ten years ago, without any problem.
I had all reference book needed.
Now instructions are so difficult to find and I don't understand
the ratio of this unavailability.

Many thanks

Alberto

May 20 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.