Access to Excel problem

[raviyah]

I have created data import links between queries in an access database and an
excel spreadsheet. Some queries work fine and the data is displayed and
updated. Other queries only display the column headers and no data.
Interestly enough, the spreadsheet seems to know how many rows of data the
query has. Any ideas?

 

[Joel]

I wonder if the data isn't in the cells but you are not seeing all the items.

Excel 2003 limits
Column width 255 characters
Length of cell contents 32,767 characters. Only 1,024 display in a cell;

Try using len(A1) to find out if the cells are really empty of that you are
not seeing all the data.

 

[raviyah]

Joel,
thank you for the idea but it is not the problem. I did a length check on
each cell and it was 0. The data is pretty simple at this point, a date, a
couple of integers and some short text. Any other ideas?

 

[Joel]

I would try opening up Access and try the queries in Access. there may be
some error messages that will help isolate the problem.
]
One possible scenario is the way you have you filters setup in the query.
Suppose you had a database with first names and e-mail addresses. Then
suppose you don't have e-mail address entered for some people. Your query was
setup to return only e-mail addreess and not first names. Now you do a query
for all Johns' email addresses. You could have 5 John's and not have any
e-mail addresses for John. The query will return 5 empty lines.

 

[raviyah]

The queries run fine in Access. They are simple queries as well.

I copied the query and made it a 'make table' query. I can import the table
into excel just fine.

Is there something I need to think about with regard to the link between
Access and Excel? If not, I may need to pursue a different avenue.

I would try opening up Access and try the queries in Access. there may be
some error messages that will help isolate the problem.
]
One possible scenario is the way you have you filters setup in the query.
Suppose you had a database with first names and e-mail addresses. Then
suppose you don't have e-mail address entered for some people. Your query was
setup to return only e-mail addreess and not first names. Now you do a query
for all Johns' email addresses. You could have 5 John's and not have any
e-mail addresses for John. The query will return 5 empty lines.

Joel,
thank you for the idea but it is not the problem. I did a length check on
each cell and it was 0. The data is pretty simple at this point, a date, a
couple of integers and some short text. Any other ideas?