Character Length with Fixed Length Imports

J

Jim DeAngelis

I am trying to import goverment data from a fixed length file. When I am
importing data the last field cuts off at approx. 600 character. Is there a
max. row/import length that can be imported? I could not find this via
online help.
 
J

John Nurick

Hi Jim,

There's a limit on the length of a line that can be imported but it's
quite long and you're far more likely to have hit the limit on the
number of characters per record in an Access table. This is nominally
2000 characters, in practice usually rather more because of the way
Unicode compression works.

There are two ways of getting round the limit. One: most wide text files
can be normalised into two or more narrower tables. Two: replace one or
more of the wider text fields with memo fields, whose contents aren't
included in the 2000 character limit.

On Mon, 9 May 2005 11:05:09 -0700, "Jim DeAngelis" <Jim
 

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

Import Fixed Length Including Spaces 1
space filled field in fixed length file 1
Importing Fixed Length File into Access 2007 1
Max Length in a row 1
Data validation, mandatory and restricted field length for excel vbs 10
importing 4,000 fixed field length records - parsing - removingspaces - etc 3
Import Fixed Length Text File 2
Is there a file size limit when importing a fixed length file? 1

Top