Importing Text files

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
 
A

Adrian Jansen

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
 
J

Jason Trolian

The problem with that is the reference # that that
specific text box is already " xxxx"
Jt
 
A

Adrian Jansen

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
 

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

Combining three files when middle file has sections with endnotes 2
Formating bolded text exclusively. 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Working on birthday "book" for my wife and having layout/editing trouble 0
When importing text field Excel chops off leading spaces 3
Need help modifying code 0
Outlook 2010 can't find .pst file 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top