EXCEL CODE

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 [email protected]
 
J

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 [email protected]
Click to expand...
 
Top