gcgcit
asked on
Need to find Specification for an excel file import.
I need to define the fields for:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Totals", Me.txtTotalsPath, True
This solution in this below link worked for me when I needed to change the specification on a .txt file
https://www.experts-exchange.com/questions/27994625/How-do-you-find-a-predefined-SpecificationName-in-a-database.html
BUT now I have a .xls file that I need to change specification and I can't find an "advanced" button... HELP!
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Totals", Me.txtTotalsPath, True
This solution in this below link worked for me when I needed to change the specification on a .txt file
https://www.experts-exchange.com/questions/27994625/How-do-you-find-a-predefined-SpecificationName-in-a-database.html
BUT now I have a .xls file that I need to change specification and I can't find an "advanced" button... HELP!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
or open the .xls file and change the column names using vba codes