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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Using Excel Macro to Import Data to Access 8
Import Excel ranges - clarify 12
Importing from Excel 4
Closing Excell from Access 3
transfer spreadsheet with spaces in the sheetname 12
How to export table from outlook into ms access table? 0
not importing properly from Excel 13

Back
Top