Is there a way to not import blank lines from Excell?

[JR]

Hello,

And thanks in advance for your help.

In excel I have several workbooks where I am dumping data. One of the
worksheets I use to bring together the data I need to export to access.

Since the number of rows vary from day to day I use formulas similar to this:
=IF(sales_by_rep_dump!B12=0,"",IF(ISERROR(INT(sales_by_rep_dump!B12)),"",(INT(sales_by_rep_dump!B12))))

When I export the data, access is importing the blank lines where there are
formulas.

Is there a way to not import the blank rows when there are formulas in the
cells?

Again, thank you for the help.

Yes answers are always appreciated.

 

[John Vinson]

Is there a way to not import the blank rows when there are formulas in the
cells?

Link to the spreadsheet (rather than Importing it directly), and use
an Append query with a criterion

IS NOT NULL

on the fields in question.

John W. Vinson[MVP]

 

[Ron2005]

Alternately, after the import, run a query that will delete rows that
are missing data in this area. (or whatever combination of empty (null)
fields uniquely defines these unwanted records.

Ron