Truncation of text field in delimited linked file

M

MPMarois

Why does Access 2007 feel it's necessary to turn the string " 03" to "03"?
In previous versions of Access if there was a leading space in a text string
Access respected it and left it in the string. What's up with 2007?
 
G

GP George

In a quick test in a query in my test database, Access 2007 does respect the
leading space in a text string, so we might need to dig deeper into your
particular situation to get to an answer.

Where and when are you seeing this behavior?
 

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

Access Truncating Linked ODBC field names 2
Determining text width & truncating 12
Splitting Text in a Field Based on a Delimiter 2
Import text file data conversion problem in Access07 2
Tab-delimited *.txt file linking; text into numbers 1
transfertext, format () does NOT work with pipes!?! 2
External table is not in the expected format. (Error 3274) 4
File Location Prompt 3

Top