Pasting Excel Formula Results as Text Into Access

[pliskers]

I am attempting to paste the output of an Excel formula into an Access table (the field is text format). Even though I have used a TRIM function in the Excel formula, when the output is pasted into Access, a blank space is inserted before and after the formula result.

Is there a way to avoid this problem?

 

[Norie]

In Excel why no try Paste Special...Values then select the range you have pasted and Copy then go to Access and Paste

 

[pliskers]

Sorry, but I don't understand your reply. Access does not offer the option to paste values. I am copying from Excel and pasting into Access. Can you describe again the sequence of steps you are recommending?

 

[bat17]

What is the format of the data you are pasting?

Peter

 

[Norie]

First in Excel, select the range you want and Copy it, then Paste Special...Values to another location in the Excel workbook or even a new Excel workbook.

Now select the range you have pasted and Copy it.

Now go to Access and Paste.

Alternatively why not use the Trim function in an Update query in Access.

 

[pliskers]

Thanks, I actually found the solution myself - I needed to format the text cells (actually, a formula that returns text) in JUSTIFIED format, not LEFT (which includes an indentation).

Problem solved!