|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 31st 05, 04:01 PM
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... 
|
| Ads |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Add-Ins for iSeries Access Data Transfer in Excel 2007 | suriahseth | New Users to Excel | 3 | November 30th 09 11:53 PM |
| Access to Excel memo-type field transfer | caloy | Excel Discussion (Misc queries) | 2 | March 6th 07 09:37 PM |
| Transfer data from Excel to Access | Secret Squirrel | Excel Discussion (Misc queries) | 1 | March 27th 06 12:07 AM |
| ADO Transfer from Excel to Access | Secret Squirrel | Excel Discussion (Misc queries) | 0 | March 26th 06 11:50 PM |
| Transfer of data from excel to access | Chris B.[_2_] | Excel Programming | 0 | December 9th 03 12:30 PM |
Linear Mode
