Importing to access - docmd.transferspreadsheet acspreadsheet parameter

[Peejay16]

I'm sure this has been asked before but I couldn't find anything on a search so please bear with me. I'm writing an access db for a charity, and part of the process means an import from an excel worksheet. I've written the import using the docmd.transferspreadsheet command and the acSpreadsheetTypeExcel8 parameter and it works fine. My concerns is that I can see the use of this parameter causing an issue in the future as PCs get upgraded to later versions of software. I appreciate I can't future proof it completely but what I'd like to do if possible is find out the spreadsheet 'version' (i.e. what file format it's saved in, excel 97-2003 etc) as part of the procedure and then use that to ensure I get the right parameter later on. Can anyone point me in the right direction to do this? Thanks

 

[boblarson]

Just leave that argument blank. It is optional anyway.

 

[Peejay16]

Thanks Bob. As you say it works but I'm still a little unsure of whether that will cause an issue anywhere. Seems strange there is no property you can retrieve in Excel to say what format a sheet is saved using?

 

[boblarson]

Thanks Bob. As you say it works but I'm still a little unsure of whether that will cause an issue anywhere. Seems strange there is no property you can retrieve in Excel to say what format a sheet is saved using?

The thing is, that you don't need to specify which format it is when importing. Now, exporting would be different in that you can decide which format to use. But importing, Access will be able to tell just fine what it needs to know if it is an Excel file.

 

[Peejay16]

Ahh - got it now - thanks Bob