Exporting data through Link Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Sorry this was meant for the Greatplains group. I have posted the query to
there.

regards
Jen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
Importing Excel Data and Comparing to Existing Data Records 4
Clean all "data" from a database 3
Exporting query to table in external database 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
Linked Table and Read Only Issue 1
Append Access Data to SQL Server Table 12

Back
Top