Exporting data from Access 2000 to Excel sheet

R

Rizla

How do get more than 250 characters in a field when exporting data from
Access 2000 to an Excel sheet?
 
K

Ken Snell [MVP]

Use a macro with the TransferSpreadsheet, or use VBA code to run the
DoCmd.TransferSpreadsheet method. The manual method (File | Export) uses the
EXCEL 95 format, which limited strings to 255 characters.
 

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

Cell data entering slow! 0
Excell Otpions in office environment 0
Excel --> Word 4
VBA - exporting serial letters to single documents 0
Publisher is filling blank lines with data 2
Exporting to Excel 0
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Exporting Data From Excel to SQL 2

Top