Linked Excel Table in Access if right Aligned (want left)

[rest]

I've been using a database as a linked table for years, but just updated the whole excel table with new address information. It's an excel table, linked into Access and the font is something odd (which I know how to change), but the alignment on everything is right.

I have gone into the whole excel table AND THE Access Table and made sure it was all left-to-right. This is the only tip I can find via "help" section and microsoft and it's not solved my problem.

I use this every day, it's my main data, but I'm not good with macros, etc. I may have bumped something, or the new excel table may be a bit different. I've pasted the new info into the old excel table, but it didn't work.

IT is left aligned if I link it to a .cvs file, but I can't do updates with this.

Please help!
Thanks in advance!

Lisa C

 

[PHV]

You may try to play with the Trim function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886