TransferSpreadsheet

  • Thread starter Thread starter DZ
  • Start date Start date
D

DZ

Hi

How can I import a specific worksheet to a specific table. Where the sheet
and table have different names. It seems from the help files, you can only do
this if they are named the sames

Excel Sheet = "SummarySheet"
Access Table = "Summaries"

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8,
"Summaries", strFullPathOfExcelFile, True

Thanks for any help.
I'll give credt to helpful responses
 
Hi

How can I import a specific worksheet to a specific table. Where the sheet
and table have different names. It seems from the help files, you can only do
this if they are named the sames

Excel Sheet = "SummarySheet"
Access Table = "Summaries"

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8,
"Summaries", strFullPathOfExcelFile, True

Thanks for any help.
I'll give credt to helpful responses
Click to expand...

how about this...

http://www.mvps.org/access/general/gen0008.htm
 
Back
Top