Re: [MSAccessProfessionals] Docmd.transferspreadsheet help

Thank You Bill. that saved a lot of time rewriting code.

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Bill Mosca <wrmosca@myself.com>
Sent: Wednesday, October 13, 2021 9:13 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Docmd.transferspreadsheet help

 

On Tue, Oct 12, 2021 at 04:35 PM, Jim Wagner wrote:

Hello all,
I have a lot of vba that transfers spreadsheets into my databases and I have been using docmd.transferspreadsheet acImport, acSpreadsheetTypeExcel12 for a very long time. But now we are getting our data from Alteryx exported to .xlsx files instead of .xls files. I have looked online and there seems to be a bit of a discrepancy between the webpages. could someone help me and direct me to the proper syntax. 
I did find the below
DoCmd.TransferSpreadsheet acImport, 10, and it works but so does the others. 
Is there ramifications of having the incorrect syntax? 

Thank You 
Jim Wagner

Hi Jim

If your older code works go ahead and use it. The difference between .xls and .xlsx usually only have to do with new features. Transferring data wouldn't change unless you were using some kind of new data type which is unlikely in this circumstance.

MS is pretty good about backwards compatible VBA when it comes to the DoCmd. And Differences in code are sometimes just variations on the same process.
 
--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com