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" wrote:

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?