Need more than 64 characters in Title field

[DavidK111]

Is anyone aware of a workaround so that I can place more characters than the 64 limited in a field header.

In essense, I need to export a text or CSV file from Access every day, and the row header for the first column (i.e, in cell A1 if opened in excel) needs to read: "Action (SiteID=US|Country=US|Currency=USD|ListingType=Hal f|Location=US|ListingDuration=GTC)"

I am currently unable to have a field header with that length, because Access does not allow my table header to be more than 64 characters.

Is there a simple solution to this problem? Thanks for any suggestions.

[DavidK111]

Also...just to be clear. I am trying to build a macro that accomplishes this, in hopes to automate the process, with the final step to be the export of the Text or CSV file.

[June7]

I don't have need to export to CSV so not familiar with nuances.

That's one field header? How does that relate to 'table header' - what is meant by 'table header'?

[DavidK111]

Sorry, thanks for pointing that out. I meant to say field header (not table header). I need to be able to export to a file that has a field header of more than 64 characters. Perhaps this isn't possible to accomplish using Access.

I may need to go through a separate step of adding code to add additional text to the Text file. I am surprised that there isn't a way to accomplish this within Access since I would imagine that I am one of many people that needs to have a column header that is longer than 64 characters.

[June7]

You want to build a table with a field name more 64 characters?

What export method are you using? If you open a textfile object in VBA and write line-by-line, I expect the string for the headers could be whatever length you want.

[ssanfu]

So there are 6 pieces of data in that one field?

needs to read: "Action (SiteID=US|Country=US|Currency=USD|ListingType=Hal f|Location=US|ListingDuration=GTC)"

I am currently unable to have a field header with that length, because Access does not allow my table header to be more than 64 characters.

I wonder what the labels for your controls look like on a form.
No offense, but, ignoring that fact that you are using special characters in the field name, having a field name that is 64 characters is..... I don't have the right word.... maybe "Odd" or "highly unusual".(IMO)

I imagine creating a query with 5 fields having 64 character names would be a real PITA.

Unless the dB is for your personal use, no one should see field names, so the actual field names don't really matter. You could use Apples, Oranges and Bananas or F1, F2, F3.

However, you could use VBA to create the text/CSV file and have the "field names" (what you call column headers) any length you want. Then loop through the record set writing the record to the file.
I use this method when I have to add info before the actual data records.

Again, my apologies. I have never heard of anyone using 64 characters for field names.

[ranman256]

I think you mean text box or label. Tables dont have headers.
text boxes can have 255 chars.
memos can have basically unlimited.

use a table field set to 255

[DavidK111]

thanks for the replies. Will give both a shot.

[Taj84]

thanks for the replies. Will give both a shot.

Hey David! Were you able to overcome the issue? Running into a similar problem.

[Welshgasman]

Hey David! Were you able to overcome the issue? Running into a similar problem.

Almost a 9 year old thread?

[isladogs]

Table and field names cannot be longer than 64 characters. It is a hard limit.
See Access specifications - Microsoft Support