Import Fixed Length Including Spaces

  • Thread starter Thread starter Ripper
  • Start date Start date
R

Ripper

I am trying to import a fixed length file and include the spaces on a text
file field. I know the spaces are included in the file as I've seen the
file. However, whenever the data is imported to the table, the spaces that
should be there are not.

Is there a setting that will allow me to have the spaces included?
 
Are these leading and / or trailing spaces? You may need to have a text
qualifier used within that file. Often these are quotation marks. Something
like:

" abc123 "

If you can't get the file sent to you that way, you could try to link to it
instead and use an append query to import the data into a table.

I'm assuming that you are trying to put this data into a text field and not
a number field. Nothing will help with numbers.
 
Back
Top