выгружаю данные из таблицы в Excel.почему то выгружает только 65535 записей. скажите в Excel есть ограничения на количество строк в листе?

Есть. Используйте 2007, но и там тоже есть ограничения. Что то в районе миллиона.

Ясно. Спасибо. тогда вручную буду делать. программно позволяет только в старый грузить.

dbf?

(2) Программно он обращается к сервису - ставь на машине 7 офис и все

программно позволяет только в старый грузить - это почему?

ЗЫ: Добавьте листов в книгу.

стоит 2007

(6) Где то вы нас обманываете. У 2007-го : Размер листа

1 048 576 строк и 16 384 столбца

http://office.microsoft.com/ru-ru/excel-help/HP010073849.aspx

я из VFP 9 выгружаю
select 0
SELECT distinct  Cenn_Szh.shifrm as шифр_материала , Cenn_Szh.nm as наим_материала ,;
Cenn_Szh.tr as типоразмер ,;
Cenn_Szh.gr as ГОСТ_на_типоразмер ,Cenn_Szh.mr as марка_материала,;
Cenn_Szh.go as ГОСТ_на_марку_материала,;
Cenn_Szh.ei as ед_измерения, Cenn_Szh.ng as N_гр_ОГТ, ogt.naimogt as Наим_грОГТ ,;
 Cenn_Szh.gm as  группы_ПЭО, Cenn_Szh.shifr_si as шифр_СИ, Cenn_Szh.nk as N_кладовки ;
FROM Cenn_Szh LEFT JOIN ogt ON Cenn_Szh.ng=ogt.Nogt AND Cenn_Szh.ng<>0  ORDER BY ng,nm,tr,gr,mr,go,ei INTO TABLE (put+"Itog\Cenn_OGT.dbf")
COPY TO (put+"Itog\Ценник") TYPE  xls

он обращается к 2003 видимо

XLS


Creates a Microsoft Excel version 2.0 worksheet file. Each field from the currently selected table becomes a column in the spreadsheet, and each record becomes a row. If you do not include a file extension, an .xls extension is assigned to the new worksheet.
Note:  
Though you can export a maximum of 65,535 rows, which includes one row reserved for the field header, versions of Excel earlier than 8.0 (Excel 97) display only the first 16,384 rows and cannot import files containing more than 32,767 rows.
из хелпа. так и есть

(10) бей на листы по каким либо признакам
зы: а цифры в нике что означают? судя по фото не год рождения

Регион )))

(11) Тверь наверное. В смысле код региона. :)

какой я распущенный, про регион и не подумал )

Тверская область,Кимры. Это ближе к Москве

mikecool, ну не ты один такой )

(16) ну слава богу, отлегло от сердца :D

(8) SQLNavigator юзай

или как там - ДДЕ запросы к базе фокса из экселя )

да я попробую разбить на таблицы и выгружать,только ведь надо в листы отдельные выгружать,а не в документ(придется подключаться к excel). Оптимально было б конечно сразу выгрузить в 2007й

мож сразу в скуль ? если есть скуль

SQL нету (((. Я тут думаю выгрузить в текст,и загрузить потом в 2007 )) быстрей получится

вообще наше руководство желает работать только с офисом

сохраняй в mxl и пересохраняй в ексель -- 1C Предприятие 8.2 - Работа с файлами - бесплатная утилита

сохранять есть возможность только в этих типах:
DIF


Creates a VisiCalc® .dif (Data Interchange Format) file. Fields from the Visual FoxPro table become vectors (columns) and records become tuples (rows). The new file name is assigned a .dif extension if you do not include an extension in FileName.
MOD


Creates a Microsoft Multiplan® version 4.01 file. The new Microsoft Multiplan file name is assigned a .mod extension if an extension is not included.
SDF


Creates an SDF (System Data Format) file. An SDF file is an ASCII text file in which records have a fixed length and end with a carriage return and line feed. Fields are not delimited. The SDF file name is assigned a .txt file extension if you do not include an extension. The SET CENTURY setting is ignored when creating SDF files with COPY TO. If SDF files include date data, it should be in YYYYMMDD format to allow effective reconversion into Visual FoxPro tables. If date information is stored in ambiguous formats, you should make sure that the dates are in YYYYMMDD format before you perform the COPY TO operation.
SYLK


Creates a SYLK (Symbolic Link) interchange file. SYLK files are used in Microsoft MultiPlan. Each field from the currently selected table becomes a column in the spreadsheet, and each record becomes a row. SYLK file names have no extension.
WK1


Creates a Lotus® 1-2-3® version 2.x spreadsheet file. Each field from the currently selected table becomes a column in the spreadsheet and each record becomes a row. A .wk1 file name extension is assigned to the new spreadsheet.
WKS


Creates a Lotus 1-2-3 version 1a spreadsheet file. Each field from the currently selected table becomes a column in the spreadsheet and each record becomes a row. A .wks file name extension is assigned to the new spreadsheet.
WR1


Creates a Lotus Symphony® version 1.1 or 1.2 spreadsheet file. Each field from the currently selected table becomes a column in the spreadsheet and each record becomes a row. A .wr1 file name extension is assigned to the new spreadsheet.
WRK


Creates a Lotus Symphony version 1.0 spreadsheet file. Each field from the currently selected table becomes a column in the spreadsheet and each record becomes a row. A .wr1 file name extension is assigned to the new spreadsheet.
CSV


Creates a comma separated value file. A CSV file has the field names as the first line in the file, and the field values in the remainder of the file are separated with commas.
XLS


Creates a Microsoft Excel version 2.0 worksheet file. Each field from the currently selected table becomes a column in the spreadsheet, and each record becomes a row. If you do not include a file extension, an .xls extension is assigned to the new worksheet.
Note:  
Though you can export a maximum of 65,535 rows, which includes one row reserved for the field header, versions of Excel earlier than 8.0 (Excel 97) display only the first 16,384 rows and cannot import files containing more than 32,767 rows.



XL5


Creates a Microsoft Excel version 5.0 workbook file. Each field from the currently selected table becomes a column in the spreadsheet, and each record becomes a row. If you do not include a file extension, an .xls extension is assigned to the new workbook.
Note:  
Though you can export a maximum of 65,535 rows, which includes one row reserved for the field header, versions of Excel earlier than 8.0 (Excel 97) display only the first 16,384 rows and cannot import files containing more than 32,767 rows.