Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - Export limit to excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft access courses - Export limit to excel

Resolved · Low Priority · Version Standard

Reply Tue 10 Jul 2007, 15:17Delegate Dan said...

Dan has attended:
Access Intermediate course

Export limit to excel

Is there any way to improve on the limit of 255 characters when eporting data from Access to Excel?

If up to 1500 characters are in a field and required to be exported how would you suggest that the detail is moved accross?

For upcoming training course dates see: Pricing & availability

Reply Mon 16 Jul 2007, 12:26Trainer Richard said...

RE: export limit to excel

Hi Dan

What is the data type you are trying to export? Text or Memo

Richard

Reply Mon 16 Jul 2007, 13:52Delegate Dan said...

RE: export limit to excel

Hi Richard,

Text. i.e. we have a database which we insert comments into a field. This needs to be exported for reporting purposes but we have a limit of 255 characters which is inadequate for our commenting purposes.

thanks

Dan

Reply Mon 16 Jul 2007, 14:10Trainer Richard said...

RE: export limit to excel

Dan,

The text field is limited to 255 as you know. The memo field however, can contain 65535 characters.

See if you can change the field to a MEMO type. I suggest making a copy of your live database and trying it on that one first, to ensure that there is no corruption. Generally seaking this type on conversation is not a problem.

The memo field has less functionality, ie(input mask etc.), but if you re only using it for the volume of info, you should be fine.

Regards

Richard

Reply Tue 17 Jul 2007, 08:35Delegate Dan said...

RE: export limit to excel

Thanks but the fields are already set to memo and the export limit to excel is still 255 characters?

Reply Thu 26 Jul 2007, 15:58Trainer Richard said...

RE: export limit to excel

ok, I will need to look into that more deeply. I will reassign this question to our other trainers and see if they can assist.

Regards

Richard

Access articles

· Why consider Access Visual Basic training?
· So You Want To Create Forms In Access 2007?
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· User-Proofing Your Access Database: Part 1
· How To Use Calculation Fields In Microsoft Access

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips