Start Position Error

[philljp390]

I'm trying to export a table as a (.txt .csv) file.

When I click Finish on the Export wizard Im getting the following error:

"The Field 'Field143' contains a start position of '32806'. The maximum start position allowed is 32767"

All records in this field are empty, but it is required.

Any ideas whats causing this error? or how to change the start position. (there is no VB programming in the database either).

Thanks

 

[Mile-O]

"The Field 'Field143' contains a start position of '32806'. The maximum start position allowed is 32767"

Any ideas whats causing this error? or how to change the start position. (there is no VB programming in the database either).

An educated guess would suggest that you've reached a limit. 32767 is the highest possible value for an Integer value. I don't have experience with what you are talking about but, unless there's anything that lets you change some property or other to a Long Integer then you might have to rethink the strategy.

Again, though, I haven't used the Export Wizard.

 

[tchucter]

strange, this is the first time I came across this error in years of exporting data from various version of Access to txt/csv files etc. It is apparently something to do with the Microsoft Basic compiler in access!! The workaround I found was to copy and paste it from the table in access to an excel worksheet, then from there save as a csv file, which can then be renamed as a txt file. Bit of a pain but it works.

 

[abell86]

I'm having the same problem exporting to csv file. I can import fine, but it won't let me export. I need all these columns as to duplicate a csv file for importing to another program. I'm working on developing an electronic timesheet system and I'm trying to automate as much of it as possible. If I could get access to export this file it would be ideal for the approach I'm testing right now. Nobody has come up with a way of working around this issue yet??

Thanks

 

[abell86]

Ok this is what I did to get around the issue. I went into the table design view, and for the fields that were always empty, but necessary to preserve for csv formatting reasons, I just changed the field size from 255 to 2. Until it worked fine. I would have made all empty fields this (maybe 0 would be a better idea, I never tried it. Seems that it would cause problems lol) but there were so many fields to go through I didn't bother.

Hope that might help anyone else having this issue.

 

[luukster]

I tried to change the field size to 0, but that didn't work. Changing it to 2 worked for me.
What an annoying error!

Workaround with exporting to excel, saving as csv and changing extension to .txt also worked, but then I still had to change the delimiter, because I needed | as delimiter, not ;.