Pasting table to a post

[CJ_London]

Copying and pasting a table or query to a post looks as expected until you save it - then its all code and unreadable. e.g.

I copy/paste:

but go to preview or save and it looks like this: what an I missing?

PricesOrderedFromFK	PricesQuantity	RegisteredOn	PricesRegisteredBy	LastOfPricesUnitPrice

Query1

[td]

159​

[/td]​

[td]

1​

[/td]​

[td]

01/03/2016​

[/td]​

[td]

126​

[/td]​

[td]

699​

[/td]​

[td]

159​

[/td]​

[td]

2​

[/td]​

[td]

01/03/2016​

[/td]​

[td]

126​

[/td]​

[td]

583​

[/td]​

[td]

159​

[/td]​

[td]

6​

[/td]​

[td]

01/03/2016​

[/td]​

[td]

126​

[/td]​

[td]

556​

[/td]​

[td]

159​

[/td]​

[td]

10​

[/td]​

[td]

01/03/2016​

[/td]​

[td]

126​

[/td]​

[td]

625​

[/td]​

[td]

159​

[/td]​

[td]

21​

[/td]​

[td]

20/12/2025​

[/td]​

[td]

126​

[/td]​

[td]

802​

[/td]​

[td]

159​

[/td]​

[td]

51​

[/td]​

[td]

17/10/2023​

[/td]​

[td]

126​

[/td]​

[td]

581​

[/td]​

[td]

159​

[/td]​

[td]

101​

[/td]​

[td]

01/03/2016​

[/td]​

[td]

126​

[/td]​

[td]

489​

[/td]​

 

[tvanstiphout]

KitaYama apparently knows how to do it: https://www.access-programmers.co.u...on-i-can-handle-right-now.335021/post-1983269

 

[tvanstiphout]

ProductID	Product Name	Unit Price
1	Chai	$18.00
2	Syrup	$10.00
3	Cajun Seasoning	$22.00
4	Olive Oil	$21.35
5	Boysenberry Spread	$25.00
6	Dried Pears	$30.00

This works: first paste the query into Excel worksheet, then copy to clipboard and paste here.

 

[DaveMD]

I can replicate @CJ_London 's issue when trying to copy/paste directly from Excel. If that is the scenario, I was able to first copy/paste from Excel to MS Word, then copy/paste from MS Word to a post here and that worked.

 

[Edgar_]

Here's a thread where I found the underlying cause and posted a solution to it, it has not been fixed apparently: it's the automatic [RIGHT][/RIGHT]
markups that generate when you paste it here, they're only visible if you click Toggle BB code from the forum's message input box.

Problem Posting a table

I really liked the feature that allowed you to post a table. I would simply copy an Access table and paste. Was super helpful in describing problems/solutions and worked great. I can no longer get it to work. It looks good in edit mode but in the posted mode it looks like this with some of...

www.access-programmers.co.uk

Pasting from Excel does not generate said markups, so it works.