| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfer Excel Worksheet to Access
I want to import from the access database.
When transfering data in from excel is there a way to refer to a specific sheet and not a specific range. The excel file I want to import from has several worksheets and I do not want to have the user set a named range as the range changes. I just want to be able to say the file name and worksheet name. The stCombine below is the file path with subdirectories. DoCmd.TransferSpreadsheet acImport, 8, "Ssaintv", stCombine, True, "" Thank you for any information... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add-Ins for iSeries Access Data Transfer in Excel 2007 | New Users to Excel | |||
| Access to Excel memo-type field transfer | Excel Discussion (Misc queries) | |||
| Transfer data from Excel to Access | Excel Discussion (Misc queries) | |||
| ADO Transfer from Excel to Access | Excel Discussion (Misc queries) | |||
| Transfer of data from excel to access | Excel Programming | |||
Threaded Mode
