I was running in the wrong format, needs to be xlsx. Thank you to everyone
for your help.

"IanC" wrote:

I haven't used XL2007, but if the file you are using is compatible with
earlier versions it will be restricted to 65536 rows (and 256 columns). The
file needs to be XL2007 format to enable data beyond this range.

--
Ian
--
"Carrie" wrote in message
...
I am using 2007 but it is ending w/ 65,536.

"Glenn" wrote:

Carrie wrote:
I am trying to run a query using other Data Sources, when I run it says
query
returned more data than will fit on a worksheet. Is there any way to
get
around this so I can get all the data?


What version of Excel are you using? Excel 2007 has 1,000,000 rows and
16,000
columns.