Text Alignment is Right in Linked Table (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

 

[ineuw]

Change the cell format of all the cells of the Excel worksheet to text. You must be using the default 'General' format which is akin to a variant in MS Access.