[Solved] Copy/Paste into MS Access

Still does this in 6.23.03.24.  Annoying.

-Bruce

Hi Bruce,

thanks for the reminder. I try to find out what is happening comparing the behavior with other editors

When I use the copy2clipboard button and paste the SQL into Notepad++ then this is the result

N++ formatting looks fine and the CRLF chars are copied using the copy2clipboard button

With VSCode it looks fine too

Now the question is. What is different with Access.

Have you already seen this discussion: https://stackoverflow.com/questions/11930109/how-do-i-force-ms-access-to-retain-its-sql-formatting

I think I have found the problem.  SQLInform copies to Windows clipboard in CF_UNICODETEXT format.  When I manually copy from the SQLInform window by selecting with mouse and pressing ctrl-C, the text is copied to the clipboard in CF_TEXT format.  Perhaps there could be an option in SQLInform to copy using CF_TEXT by default?  I have a workaround so it's not terribly important.  Thank you for looking into it!

@bbhulsey currently I use the ANSI Text Format

I could give the Unicode-Format a try.

@bbhulsey could you please download https://www.sqlinform.com/app/SQLinFormDesktopCopyFormat.zip

and start the Desktop app

There are 2 new buttons. Could you please test if one of them is fine for you.

Hi @guido, thanks for trying, I really do appreciate it.  Unfortunately it appears that the utf button performs identically to the existing Copy SQL 2 Clipboard button and the rtf button does not place usable text on the clipboard at all (it does not result in a paste option being available in Access).  I used the Nirsoft InsideClipboard utility at https://www.nirsoft.net/utils/inside_clipboard.html to compare the results of all three copy to clipboard operations (the original Copy SQL 2 Clipboard button, the utf button, and the rtf button) plus simply copying the text from SQLInform results box using ctrl-C, and copying from Notepad using ctrl-C:

1. Using the original Copy SQL 2 Clipboard button (results in UTF in the clipboard):

2. Using the utf button (identical result to clicking the original Copy SQL 2 Clipboard button - still results in UTF in the clipboard):

3. Using the rtf button:

4. Copying directly from SQLInform results window using ctrl-C (this places a lot of things on the clipboard but works with a simple ctrl-V to paste into Access SQL window)

5. Copying from Notepad using ctrl-C (also works with a simple ctrl-V to paste into Access SQL window)

@bbhulsey ,

thanks for your patience.

Finally I found the issue (and therefore the solution). It was too simple.

Please download the newest release (empty your browser's cache) and give the new release 6.23.04.11 a try.

I added a new copy button.

@admin Hello Guido, the new copy button works well for MS Access.  Rather than confuse other users perhaps the preferred copy method could be implemented as a general setting rather than as an extra button?  Just a thought.  It seems to work well and thank you very much for your work on this issue!

@bbhulsey good thought, I removed the old copy button and kept the new one. I think crlf will alwys work as linebreak in Windows environment

Regards

Guido