Linked Tables

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
 
W

Wayne Morgan

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.
 

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

Adding data to MS Access from csv file 0
Dealing with a Pivot Table (when I don't want to) 0
Linking data in MS Word into Excel 5
Linked SQL Tables don't report Cascading Updates and Deletes 2
Create new record in a table not linked to a form 1
Linking Access to selected fields in a large external table 1
best way to make linked database - Stand alone 3
Cannot link to Outlook Contacts 0

Top