Import Excel Files and Errors

[Karl Burrows]

I am trying to import a regular update we receive from our national office
to update our contact information we keep in a database (2000/XP).

My first question is if I do an import, will it update the existing records
or overwrite them (the import has the primary key in it, but doesn't include
many of the other fields we have added.

Secondly, if I run a test to see how it works, I am getting an error message
about field references and primary key. What would you recommend as the
best way to import updates?

Thanks!

 

[hansford.cornett]

-----Original Message-----
I am trying to import a regular update we receive from our national office
to update our contact information we keep in a database (2000/XP).

My first question is if I do an import, will it update the existing records
or overwrite them (the import has the primary key in it, but doesn't include
many of the other fields we have added.

Secondly, if I run a test to see how it works, I am getting an error message
about field references and primary key. What would you recommend as the
best way to import updates?

Thanks!

--
Remove 'spam' from email address to contact me directly


.
This is kinda hard to just state as it could create a

problem. Save your table first then do an update querry.
It will write over only the fields that match up leaving
the others as they are. I would import to a UPDATETable
then run a update query from there to a bkup copy of my
the original table I want to update.

 

[Karl Burrows]

Okay, that makes sense. Now, where can I find some information on creating
and running an update query?

Thanks for the reply!!

-----Original Message-----
I am trying to import a regular update we receive from our national office
to update our contact information we keep in a database (2000/XP).

My first question is if I do an import, will it update the existing records
or overwrite them (the import has the primary key in it, but doesn't include
many of the other fields we have added.

Secondly, if I run a test to see how it works, I am getting an error message
about field references and primary key. What would you recommend as the
best way to import updates?

Thanks!

--
Remove 'spam' from email address to contact me directly


.
This is kinda hard to just state as it could create a

problem. Save your table first then do an update querry.
It will write over only the fields that match up leaving
the others as they are. I would import to a UPDATETable
then run a update query from there to a bkup copy of my
the original table I want to update.