EXPORT CSV ERROR

  • Thread starter Thread starter anon
  • Start date Start date
A

anon

I am trying to export a file (from access to a .csv file)
that has 214 columns.

But the export fails and comes up with this error.

The field "field name" contains a start position of 32896.
The maximum start position allowed is 32767.

Does anyone know a fix to this or a way around this
problem.

PLEASE HELP.

MUCH THANKS.
 
Hi Anon

I had the same problem in the past with a query containing 140 columns/fields
There is a maximum of characters in one line and you have exceeded this. ;-

I don't know your query and data in the columns. The only thing what you can do, is to make the fields smaller
In case you have a lot of text fields, check them if they all have the max of 255 chars, this is a good point to start with. Probably you can make a Make-Table Query out of your already existing query, amend the field sizes and export the table
As second step I would suggest create a Delete Query to remove any data from that table and to change the Make-Table Query to an Append Query

HT
Bernd
 
Back
Top