export more than 65000 rows to a text file

G

Guest

Hi, in the previous version of Access (I'm using Access 2007 now), I could
export over 135000 rows to a text file for further processing/submission.
With Access 2007 I get constantly the (error) message that I only can export
about 65000 rows.
Does anyone know how I can overcome this restriction?
Thanks
 
G

Guest

Not at all familiar with Access 2007, but if you cannot do it using a basic
export menu item or macro, have you tried writing some code that would open a
file for output and then writing individual rows (records) to that file?

Dale
 
G

Guest

Dale,
thanks for your answer. However, I'm not familiair in writing scripts or
code.
I'm a 'menu - button' user!
 
P

Pete D.

Are you sure your using the text export as the number you seeing as max is
the limit to MS Excel. Pete D.
 

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

Similar Threads

Export Access table to Excel that has more than 65000 records 5
2007 Data Export Limit 2
Exporting from Access to text 2
Importing Problem 1
Export to Excel > 65000 Rows 3
Export/Import .dat file extension 2
How can i handle more than 65000 rows in excel 3
Problems exporting large query results to text delimited format 2

Top