EXCEL CODE

[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)

 

[John Nurick]

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)