I use DataToClip(,,3) all the time in dev mode but you do have a potential race condition to keep in mind as any process that hits the Windows clipboard could replace your buffer.
-- rk -----Original Message----- From: ProfoxTech <[email protected]> On Behalf Of Joe Yoder Sent: Monday, September 20, 2021 12:09 PM To: [email protected] Subject: Re: Data transfer design Data transfer design (VFP to Google Sheets) Thanks Ted and Dave for the reponses! It turns out that in my current case the DataToClip approach works perfectly. I was totally surprised that it could be so simple. (I was using copy to type XL5 when I wrote to a file so I expected I would need to pass that detail to DataToClip. I guess the clipboard only cares about the values.) Doing it this way eliminates the need to create a file, upload the file to Google Drive, and find and import that file to Sheets If I get into a situation where I need a more elegant solution I can consider ODBC or Chilkat. Thanks again - Joe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/mn2pr10mb340769d1215b3004bc8dc139d2...@mn2pr10mb3407.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
