EXCEL CODE

  • Thread starter Thread starter bteitelbaum
  • Start date Start date
B

bteitelbaum

I have a code:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Test
Import Specification", mytxtbox, True, "Heffalump!"

This code takes excel spreadsheet, tab named Heffalump and puts ALL the
data in access table named Test Import Specification.

What I need is to specify the Range A:CS. I do not want to take all the
field.
What is the syntax? Range = A:CS.. Please answer with the correct code.


Please answer to (e-mail address removed)
 
Use
"Heffalump$A:CS"

I have a code:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Test
Import Specification", mytxtbox, True, "Heffalump!"

This code takes excel spreadsheet, tab named Heffalump and puts ALL the
data in access table named Test Import Specification.

What I need is to specify the Range A:CS. I do not want to take all the
field.
What is the syntax? Range = A:CS.. Please answer with the correct code.


Please answer to (e-mail address removed)
Click to expand...
 
Back
Top