| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Specify a range when using 'Import data'
Hi all,
I want to import a range of data from another excel worksheet, I can get the whole sheet, but am not sure of how to specify a range. I get to 'import data' & i think i should go to 'edit query' where i find the window 'Edit OLE DB Query' ....is this where i specify a range? if so i need to know the exact syntax please. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
| External Data Range Import to a Cell not Table | Excel Discussion (Misc queries) | |||
| import csv data into a range with merged cells without unmerging | Excel Discussion (Misc queries) | |||
| Named Range DTS Import of Excel Data | Excel Discussion (Misc queries) | |||
| Outlook wants an Excel named range to import contact data why? | Excel Discussion (Misc queries) | |||
Linear Mode
