Importing data

Question

I am trying to import data , so that it overwrites information in an existing table, I go through the import steps but when it finishes, I get the message Can't overwrite existing table or query

Answer 1

Do you have a Primary Key - some field that uniquely identifies the record? If not, how can you tell whether you want to replace the record that's already there, or add a new record? Where are you importing from, what are you importing into, and just what are you expecting to happen?

Answer 2

Hi Tom,

I am just doing an import and I choose the Import the source data into a new table in the current database, then through the steps I can choose which table I wish to overwrite and type this in and go from there.  This is just in the testing stage, but I have been able to import the data 2 or 3 times before with new info in the address etc, and haven't had an issue, but now I do.

Any ideas

Answer 3

"so that it overwrites information in an existing table": I don't think that's possible with the import wizard. How exactly are you doing that?

If I try to do that, it will create a new object, e.g. Customers1, Customers2, etc.

Answer 4

I am just doing an import and I choose the Import the source data into a new table in the current database.  I have done this a couple of times and it has worked fine.  But now I have the message as I stated before.

Answer 5

What is the process you are using?

You either need to delete and append or join and update.