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

Importing

P: n/a
G
I have this table called cheques. There is another external database with
the same table (same fields etc). When i import the data from this external
database into mine, it simply creates a new table called Cheques1. How can
i arrange that it simply imports all that data directly into my cheque table
?
thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sun, 19 Oct 2003 09:06:55 +1000, "G" <sk**@optusnet.com.au> wrote:

Link that table to your main database. It may be named Cheques1.
Then write an append query to copy over the data. Something like:
insert into Cheques
select * from Cheques1

-Tom.

I have this table called cheques. There is another external database with
the same table (same fields etc). When i import the data from this external
database into mine, it simply creates a new table called Cheques1. How can
i arrange that it simply imports all that data directly into my cheque table
?
thanks.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.