Issue with TransferSpeadsheet

[Terry Lawson]

I'm trying to import a spreadsheet which I download from a trusted website using:



DoCmd.TransferSpreadsheet , , "Sheet1", strPath & "" & strName, False, "A:I"

The issue I'm having is that if I download the spreadsheet then the import does not include column A, if however I then open and save the spreadsheet the import works OK.

Both the download and the re-saved file appear to have exactly the same properties, including attributes, with the sole exception that the download size is 84.5K whilst the re-save size is 80.0K

Both .xls files and Excel 97-2003.

Any thoughts please?

Regards

Terry Lawson

[CJ_London]

I have never experienced the problem but notice you do not complete the optional spreadsheet type - perhaps complete it - here is a link to the different types

https://msdn.microsoft.com/en-us/vba...eration-access

[Terry Lawson]

Yup

Tried adding a variety of spreadsheet types no difference

[Minty]

When it's downloaded it will not open for editing correctly the first time without you enabling it as an "safe" trusted internet source.
I'm not sure you can get around that in VBA? Maybe someone else has?

[ranman256]

docmd.TransferSpreadsheet acExport ,acSpreadsheetTypeExcel12,vQry, vFile, true,vSheetName

it always works.

[Minty]

@Ranman - Terry is importing not exporting.

[Terry Lawson]

Thanks all

This may not be the correct forum to post the next question but as very hopeful with you very knowledgeable guys and girls.

How do I enable a "safe" trusted internet source from either inside or outside Access?

Back to the OP, I don't think that I mentioned that the spreadsheet when opened from the download is in "Compatibility" mode