Append table/import data problems!

[Guest]

I am trying to import data from a linked excel table into a new access table
with an autonumber for primary key. I created the access table (table1) by
running a maketable query on the xl data, then in design view added an extra
autonumber field at the end for the key.
To import the data i save the original maketable query as an append, and
copy the query to create a delete query. When i need to refresh the data (and
get new pkeys) i just run the delete query to clear the table then the append
query to add the new data.
Problem is this only seems to work a couple of times before i get "Numeric
Field Overflow" on the append query! i have been through the "table1" and
confirmed all fields are the same type as in the linked excel.
In the excel table data is text/numbers or dates. some of the fields return
#Num! ?

Each time i the query runs maybe twice before breaking down, and trying to
run the delete and append query in a macro causes the error first time.

Any ideas - this is driving me crazy and i'm sure it should be a basic
function!!! I;m relativly new to access so im hoping this is something simple
i've missed....
thx

 

[Guest]

Try compacting/repairing your db. You may want to set your db to compact on
close.

 

[Ron2005]

The occurance of the #Num is why I have backed off of trying to use
linked excell tables.

Instead I always import the native excell spreadsheet into a true
access table. That approach has resolved a whole lot of problems I was
having with the linked table.

In essence that is what you are trying to do anyway.

Ron