Delete blank records from linked table

[arifmasum]

Dear all,

I am stuck here. I want to delete the blank records from the linked table. Then I want to use that table. But I can not understand how I can delete blank rows from table? Is it possible? When I link table, i get blank rows between every row.

Please find the text file attached.

If someone helps, that will be much appritiated. Thanks in advance for your time.

Arif Masum

 

[Mike375]

Just make a Delete query and on the Criteria row type Is Null

 

[doco]

Just make a Delete query and on the Criteria row type Is Null

That wont work on a linked table. the following error will result

Deleting data in a linked table is not supported by this ISAM

So create a query that is the inverse of that

SELECT 
    attend  -- field in table
FROM
    attend  -- linked table
WHERE
    attend Is Not Null

 

[Mike375]

That is interesting. You are right, when I linked to the text field the query did what you said. But of course if I import to Access and then link to the table once it is in Access then the query deletes from the linked table.

 

[arifmasum]

Well, Thanks a lot guys for your valuable advices. I got your point. It is more logical to import than link. Now I need to know, can i run the query or SQL code without being asked to be sure to delete? Is it possible, how?

Thanks in advance for your valuable comments.

Arif Masum

 

[Mike375]

Use code or macro to OpenQuery and SetWarnings No

DoCmd.SetWarnings False

In macro SetWarnings is an action line and No is selected.

That lets the query or queries run without any pop up confirmation boxes appearing