Importing Text files

  • Thread starter Thread starter Jason Trolian
  • Start date Start date
J

Jason Trolian

I am trying to import a text file. The first column of
this file has an account reference # that is 6 characters
long " 1234" When viewing the text file those spaces
exist. When I import the file access is eliminating those
spaces. What do I need to do in the import process to
insure those leading spaces remain?

Jason
 
Access always drops leading spaces in text within the tables. But you can
set the format for display in a form or report to show a fixed text length.

eg in the Format property of the textbox, set "######" to display at least 6
characters.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
The problem with that is the reference # that that
specific text box is already " xxxx"
Jt
 
Sorry, I dont follow you. I presumed you are using the character # as
shorthand for the word "number". However there is a specific use for the
character # when used as part of a Format expression, to mean "any
character, or fill in a blank, if the text is not long enough". I dont
quite see how this relates to your last comment.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top