TransferSpreadsheet

  • Thread starter Thread starter Ellen
  • Start date Start date
E

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
 
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
Click to expand...

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