asked on

MS excel database query

Hi,

I am running a data base query into excel 2007 from access 2007. I brought all the columns across from access into excel. Is there a way to only bring across records that have data?

Thanks in advance.

SOLUTION

als315

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Anuroopsundd

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Reyesrj

ASKER

Thanks for the reply,

I have 10 rows and 15 columns that came accross. Only 3 rows and 5 columns have data. Is there a way to only have those 3 rows and all the columns come accross? Meaning to say, only bring accross the records that have data.

SOLUTION

Hamed Nasr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Reyesrj

ASKER

Please see that attached query result in excel.

Rows 5,6 and 9 have data in column c through M. The outher rows do not have data. So, is there a way to only bring accross records that have data in column c through 9?

Thanks

Jeffrey Coachman

<Please see that attached query result in excel.>
Attached where?

Reyesrj

ASKER

Sorry, I'm at home. I guess the attachment did not attach. I'll send it tomorrow.
Thanks.

ASKER CERTIFIED SOLUTION