New Problem in my DB"ACCESS"

[ganal]

Hallo,
Thought I would say Hi and I have a problem in my database ... I need to convert formic to Excel and search on Google and found part of the solution to the problem in your site
But I almost need to show a large number of lines (ROWS) 50,000-row when run command message appears: -

There are too many rows to output, based on the limitation specified by the output format r by as-store.]
I hope to help solve the problem
Thank you for all

Cheers,
Ganal

 

[Ranman256]

your question is a bit unclear..
are you trying to export large volume of records to old Excel? limit 65k rows.
and old access .mdb

do you have newer access 2007 and new excel 2007? it can save 1.2 million rows.

 

[ganal]

Thanks for the quick response;
I am new to the site and I wanted to put pictures to illustrate the rejection of the administration Site,

Yes I want to export a number of rows is estimated at 50,000 and i have office 2007

 

[Ranman256]

2007 can export 1 million rows

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12 acSpreadsheetTypeExcel12, qry, File, True