output file

[geebee]

hi,

i have the following code:
docmd.outputto actable, nwfile, "microsoftexcelbiff8(*.xls)", "C:\path..." &
NewFile & ".csv", false, "",0

i am getting an error message:
"runtime error 2306: there are too many rows to output, based on the
limitation specified by the output format or by miscorsoft access"

i am not sure hwat to do now. i want tables to beoutput in csv format.

thanks in advance,
geebee

 

[Arvin Meyer [MVP]]

Excel, handles from 16,000 rows in 16 bit versions to 64,000 rows in 32 bit
versions. Excel 2007 will handle a million rows (of course it may take a
while to open) If you are exceeding these numbers, you'll have to change
your output to a query which will limit the output.

 

[geebee]

hi,

i would rathr not limit the rows. is there somethingi can use besides
microsoftexcelbiff8(*.xls) or is therea way i can output strictly csv file or
text file or something. or use code to specify 32 bit version?

thanks in advance,
geebee

 

[Arvin Meyer [MVP]]

Yes, you are already outputting to a text file, just chance the receiving
file and path to a text file instead of Excel. When opening, right-click and
tell it to open with Notepad.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com