| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access command from Excel
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...... -- JT |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I access favorites in the Excel 2007 Open file command | Setting up and Configuration of Excel | |||
| Printing Access reports through Excel command button? | Excel Discussion (Misc queries) | |||
| Open Access DB in Excel with Command Button | Excel Programming | |||
| Open Access DB in Excel with Command Button | Excel Programming | |||
| Open Access DB in Excel with Command Button | Excel Programming | |||
Threaded Mode
