Access command from Excel

  • Thread starter Thread starter JT
  • Start date Start date
J

JT

In my Excel macro, I am trying to import a spreadsheet into Access. I create
an Access object and am trying to use the "transfer spreadsheet" command. It
works but it is only importing the first line in the spreadsheet.

Below is the code I'm using:

AppAcc.DoCmd.TransferSpreadsheet acImport, 8, "Interest_Table",
"\\vs300\cost_center\ABC\UploadFile.xls", True

Any ideas or suggestions are greatly appreciated. Thanks for the help......
 
Aghhhh, just re-read you posting, it says you are trying to export from
Excel? However, you have posted the VB for importing into Access
(TransferSpreadsheet acImport)? So I am now totally lost? Perhaps AppAcc is
an excel code but surely your should then be exporting????

Kindest Regards
 
Back
Top