import excel

[kolait]

Hello friends
I want to import an Excel file with the .xls extension. But according to the photo, only the extension (xlsx) is imported. Thanks for helping me.

 

[vba_php]

the "transferspreadsheet" method ur using has many options available in it, one of which should be the .xls extension instead of .xlsx. after you type the comma "," at the end of "acImport", a dropdown menu should automatically appear for you where you can select other options.

 

[isladogs]

See this MS article about the different options available https://docs.microsoft.com/en-us/office/vba/api/access.acspreadsheettype

 

[kolait]

the "transferspreadsheet" method ur using has many options available in it, one of which should be the .xls extension instead of .xlsx. after you type the comma "," at the end of "acImport", a dropdown menu should automatically appear for you where you can select other options.

Hi
thank you very much
My problem was solved

 

[kolait]

See this MS article about the different options available https://docs.microsoft.com/en-us/office/vba/api/access.acspreadsheettype

Hi
thank you very much
My problem was solved

 

[kolait]

Hi
I have an Excel file ready
I would like to export the access table information in the range below.
Thanks for the guidance.
Range (A10-D10)

 

[theDBguy]

Hi
I have an Excel file ready
I would like to export the access table information in the range below.
Thanks for the guidance.
Range (A10-D10)

Hi. You should be able to use the TransferSpreadsheet method to export the table into your Excel file and use the Range argument.