A
alexasha
I periodically need to export records from one web-based database to access
database. The only way I found to do it is to copy web-based table to excel.
Then I imported this table to access through <get external data> <Link
Tables>. The idea is that I will need to copy this data once to excel and
then through append query place in my database.
Now the problem.
Initially I had 15 records, which I exported without problems. Next time I
had 7 records, but append query still exports 15 records (8 of them are
empty) thus generating bunch of empty records with unique autonumber. I have
tried to delete empty records in Linked table in access (the one that was
created by <get external data> <Link Tables>. But I am not allowed to do
that.
Any solutions, please?
database. The only way I found to do it is to copy web-based table to excel.
Then I imported this table to access through <get external data> <Link
Tables>. The idea is that I will need to copy this data once to excel and
then through append query place in my database.
Now the problem.
Initially I had 15 records, which I exported without problems. Next time I
had 7 records, but append query still exports 15 records (8 of them are
empty) thus generating bunch of empty records with unique autonumber. I have
tried to delete empty records in Linked table in access (the one that was
created by <get external data> <Link Tables>. But I am not allowed to do
that.
Any solutions, please?