external data-1/2 spaces

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm pulling data from a server-based database. I have to copy/paste to put
info into Excel and then into Access. The problem is on this one field (the
primary key field) where the data comes off of the initital database with a
1/2 space before each record. Subsequently, I'm unable to link this field
once it gets to Access and run queries, etc..I've tried left justifying the
field in Excel and a couple of functions to try and force it over (its been a
while since I've worked on this problem and I can't remember what they were).
Does anyone have any suggestions?
 
In Excel, before importing into Access, you could TRIM() the field in question.
TRIM() removes all spaces, except a space between words.
 
Back
Top