RE: Data transfer design Data transfer design (VFP to Google Sheets)

PM To: profoxt...@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

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 c

RE: Data transfer design Data transfer design (VFP to Google Sheets)

Joe, Data2Clip is a possibility but beware that the data transformation from VFP to Spreadsheet can be unpredictable and not result in a data type you expect. Are you uploading the data in Sheet format or in an intermediate FORMAT LIKE csv? I would do as Ted suggests and look at external source

Re: Data transfer design Data transfer design (VFP to Google Sheets)

Hi, Joe: I did a lot of work, back in the day, moving FoxPro data from DBFs to other places: SQL Server, MySQL, etc. via ODBC and it gives you a lot of control. A quick web search seems to indicate several vendors have drivers to feed various Google services, including sheets. You might want to co