SQL Select statement not populating cells properly.

[brent_milne]

I have an SQL SELECT statement that connects to the database fine but it will only populate the top cell for my last field.

eg. SELECT ID, Date, Number, Pickup FROM tbl_test WHERE Pickup='condition 1'

If there are 100 hundred records returned into the sheet columns A= all of the ID B=all of Date C=all Number but D only has one record at the top (d1). There is data in the database for the matching records but why will it only show up in one cell. It is a memo field in the database but that shouldn't matter if it displays one record. I hope I explained this enough and thanks for any help.

[AlKey]

Try first without WHERE clause and see if you get more records. If you do get more records then the problem could be trailing zeros.

[pjwhitfield]

how are you outputting the data?

are you using Range.CopyfromRecordset?

[brent_milne]

Removed the WHERE clause and did get more records and now I have 3 cells that contain the data from the memo field. I know there is data in the database in that memo field but no idea why it won't populate the cell.
Thanks

[brent_milne]

Yes I am using Range.CopyFromRecordset.

[brent_milne]

I have deleted everything from my SELECT statement except for 'Pickup' which was the only memo field in the statement and still only get one record returned. All the other fields are text or numbers and they are returned for all the records. The only difference I can find is the memo field but not sure how I can work around this.

[pjwhitfield]

Try cycling through the recordset and assigning the field to a String variable before outputting the data to the spreadsheet.