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 profoxtech-bounces@leafe.com On Behalf Of Joe Yoder Sent: Monday, September 20, 2021 12:09 PM To: profoxtech@leafe.com 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