TransferSpreadsheet

[Ellen]

Hello,
I'd like to import an Excel spreadsheet with long (memo-
lenght) text strings using a macro or VBA code to run the
TransferSpreadsheet action. Can someone tell me how to
import A1:B1 of my spreadsheet
(C:\UnifiedTables\SCOGStest4.xls) into Access table
(Sheet2)

Thanks in advance,
Ellen

 

[fredg]

Hello,
I'd like to import an Excel spreadsheet with long (memo-
lenght) text strings using a macro or VBA code to run the
TransferSpreadsheet action. Can someone tell me how to
import A1:B1 of my spreadsheet
(C:\UnifiedTables\SCOGStest4.xls) into Access table
(Sheet2)

Thanks in advance,
Ellen

Did you read VBA help on the TransferSpreadsheet method?
The example given specifically shows importing a range of data.