Please help me,
I am designing a small application that takes an excel sheet , this sheet contains my students marks inside a table named grade1.
I want to import this table to my access table I use this command:
DoCmd.TransferS preadsheet acImport, acSpreadsheetTy peExcel12, "Grade1A", varFile, True, "grade1A"
but I dont want to put the name of the range " grade1A" , I just want access...
Sally O Askar
Last Activity: Jan 6 '11, 10:02 AM
Joined: Nov 28 '10
Location:
-
Sally O Askar started a topic Extract the name of the defined named tables inside an excel sheet to accessin AccessExtract the name of the defined named tables inside an excel sheet to access
No activity results to display