Linked Tables

  • Thread starter Thread starter xpnovice
  • Start date Start date
X

xpnovice

I have an customer appointments table which is linked to a basic Excel
spreadsheet which is updated on a daily basis. From this I generate various
queries and report in Access. One problem I have thought is that the link
seems to generate spurious blank records, i.e. if I have 300 genuine records
in my spreadsheet, but my report in access I get my 300 genuine records, but
there will often be additional blank records, say up to 1066. When I check
the linked table, sure enough there are blank records also in the table.
Question is, how do I ensure that the link only brings in those rows
(records) that contain data. Thanks in advance

John
 
I'm guessing it is the way they are clearing the previous records in Excel.
They are probably leaving an empty string in the cell instead of Null. Try
using a query between the table and your form or report to remove these
records by using criteria in the query.
 
Back
Top