import data into existing database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've create a database by importing source data into the db. I've created
several queries from that db.

Now, If I update the source data by importing the source data again, do I
need to re-create my queries or can I just use the queries again?
 
No, you don't need to recreate your queries if you import the source data
again (assuming that you saved the q
 
No, you don't need to recreate your queries if you import the source data
again (assuming that you saved the q
 
No, you don't need to recreate your queries if you import the source data
again (assuming that you saved the q
 
Sorry, problems with the tab kay...

No, you don't need to recreate your queries if you import the source data
again (assuming that you saved the queries in the first place).

However, when you import data, Access doesn't overwrite the existing data
in your tables, but appends it. So if you've got unique indexes, not all
the data may import. If you're re-importing all of your data again, it's
normally a good idea to delete the entire contents of the tables it's going
into first.
 
Back
Top