Access import data from excel but no update

[MiRoT]

Hello.
I Have this Table (named pelates) in Access
kwdikos_pelath --- number(primary key)
onomatepwnymo
thlefwno
hmeromhnia --- date
poso

And i create also this Excel file (named work pelates)
A1 - kwdikos_pelath
B1 - onomatepwnymo
C1 - thlefwno
D1 - hmeromhnia
E1 - poso
and i add some values.

Then i try to Access, file -> import data and i recieved all datas from Excel.
When i make some changes to Excel (add new values, delete old values and
rewrite data on the old kwdikos_pelath(primary key), i got an error like
can't write second datas (cause of primary key).
Is there a way to copy new datas and also update old datas with new values?
(I have no knowlege on Visual Basic)
Thanks.

[AFSSkier]

Have you tried Linking to the Excel file, rather than Import?

When you Link, the Excel file can be updated as needed. And the file can be
used as a table in Access.

--
Kevin

[Douglas J. Steele]

Actually, because of losing a lawsuit a few years ago, Microsoft was forced
to remove the ability to update linked Excel files.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"AFSSkier" <AFSS...@discussions.microsoft.com> wrote in message
news:534AC489-E5AC-4115...@microsoft.com...

[JORGE]

"MiRoT" <Mi...@discussions.microsoft.com> wrote in message
news:1D28B2A8-78C8-4B4E...@microsoft.com...

[Laoshu]

"AFSSkier" <AFSS...@discussions.microsoft.com> 写入消息
news:534AC489-E5AC-4115...@microsoft.com...

[b-fleig]

"AFSSkier" <AFSS...@discussions.microsoft.com> schrieb im Newsbeitrag
news:534AC489-E5AC-4115...@microsoft.com...