Access command from Excel

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......
 
M

MikeJohnB

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
Access Subscript out of range when importing into access 2010 from excel 0
transfer spreadsheet with spaces in the sheetname 12
Transfer Spreadsheet; Import Only UsedRange 2
Import Excel sheets to Access 2

Top