2007 Data Export Limit


Z

zyus

I'm using Access & Excel 2007.

When i try to export data to excel from my query, the number of records is
only limited to 65000 rows.

I thought that 2007 excel can handle more than 65000 rows.

Appreciate any advise.

Thanks
 
Ad

Advertisements

G

Gina Whipp

zyus,

Yes it can handle 1mil rows... or there about. Are you using the
TransferSpreadsheet method? Like...

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "QueryName",
Output_Path_And_File

A macro?

Would hep if we could see what you are using...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I'm using Access & Excel 2007.

When i try to export data to excel from my query, the number of records is
only limited to 65000 rows.

I thought that 2007 excel can handle more than 65000 rows.

Appreciate any advise.

Thanks
 
Ad

Advertisements

A

a a r o n . k e m p f

Sounds to me like you should be using SQL Server and an ETL tool
so so so so so very sorry that Access is stuck in the stone ages
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top