output file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Back
Top