Transfer Spraedsheet problem

[spock1971]

Can anybody help please.

I've set up a database and built a query to export records to excel.

However, it appears to truncate the export at 150 rows. I've run the query in access and it brings back 170 rows.

Ideas?

D

 

[Tony1258]

I know this may add a little more to your process but set up a macro to run a make table query and then run an export of the table to excel this may get all the data.