Pages: [1]   Go Down
Author Topic: MS Access/Excel Copy/Paste Woes  (Read 1036 times)
0 Members and 1 Guest are viewing this topic.
0
Offline Offline
Full Member
***
Karma: 2
Posts: 226
#include˂baby.h˃™
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

I've poked around a bit looking for a solution. I'm using Office 2010.

When I copy/paste a single record from Access to Notepad, it works fine. When I copy/paste several records, Windows seems to add extra quotes around just some of the records and makes some of the double quotes turn into double-double quotes ""!""

Another problem I had was when exporting a table to plain text, even though the field is set to Memo, I was experiencing field truncating to 255 characters.


The quote issue seems to happen with Excel as well - this is not a solution, so no need to click:
http://www.excelforum.com/excel-general/650997-remove-double-quote-marks-when-pasting-into-notepad.html
Logged

Global Moderator
Boston area, metrowest
Online Online
Brattain Member
*****
Karma: 533
Posts: 26944
Author of "Arduino for Teens". Available for Design & Build services. Now with Unlimited Eagle board sizes!
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

How is this Arduino related?
Logged

Designing & building electrical circuits for over 25 years. Check out the ATMega1284P based Bobuino and other '328P & '1284P creations & offerings at  www.crossroadsfencing.com/BobuinoRev17.
Arduino for Teens available at Amazon.com.

0
Offline Offline
Full Member
***
Karma: 2
Posts: 226
#include˂baby.h˃™
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Arduino is only indirectly related to the extent of by me keeping my sanity, I'll be able to continue playing with Arduino.

I'm just going to write a VBA function and forget about trying to understand MS idiosyncrasies.

Quote
General Category -
New Posts   General Discussion
Feel free to talk about anything and everything in this board.
Last post: Re: MS Access/Excel Copy... by CrossRoads on Today at 05:42:42 am
Moderators: admin, Massimo Banzi, David Cuartielles, mellis
Logged

Pages: [1]   Go Up
Jump to: