Deleteing blank row in a linked table 1

[anonymous26]

I have a report that is automated to save as a text file, but it saves it with a heading and one extra line of space. So when I link the table in access there is a blank row at the top but i can't delete it because it's a linked table. I'm trying to export the table as text. Is there any way to remove the blank line?

 

[Golom]

Why can't you delete it? I can add/delete/modify data in linked tables with no problem.

You mentioned both a Report and a Table. Which are you trying to Export?

You could just build a query

Select * From myTable
Where fld1 IS NOT NULL

That should drop the blank line and you can export the query.

 

[anonymous26]

oops thanks

 

[cheerio]

Generally Access will not allow deletes on a linked table if there is no primary key. It is likely that the table has no primary key if it is simply a report image.