Import Excel Files and Errors

  • Thread starter Thread starter Karl Burrows
  • Start date Start date
K

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!
 
-----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
Click to expand...
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.
 
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
Click to expand...
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.
 
1 - The help file

2 - The "Access 2002 Developer's Handbook" by Ken Getz, et. al. from Sybex

3 - "Microsoft® Office Access 2003 Inside Out" by John L. Viescas from Microsoft Press

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Back
Top