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

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27994625.html

BUT now I have a .xls file that I need to change specification and I can't find an "advanced" button...  HELP!
gcgcitAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
there is no import specification needed to import a .xls, .xlsx files

what you  need to do, is to import the excel file into a temp Table

then do what you need to do, using the temp Table
0
 
Rey Obrero (Capricorn1)Commented:
or open the .xls file and change the column names using vba codes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.