Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to import external data with two types of rows. On the top should be
a title with different widths, and on the bottom will be the data. Both of these types of data are coming from the same external source. I am using excel 2003. Thanks! Example: Quicksilver Oil Company Well Name Data Data Data ..01 .01 .01 ..02 .02 .02 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
the best way is tto generate the data with commas between fields. The comma
tells excel to put the data in the next column. Putting two comma together like 12,,13 tells excel to put 12 in column A and 13 in column C. then call the file with a .CSV extension. Excel will open .CSV files automatically. Also you can Import CSV files into other workbooks use the Data - Import feature. "Renny03" wrote: I want to import external data with two types of rows. On the top should be a title with different widths, and on the bottom will be the data. Both of these types of data are coming from the same external source. I am using excel 2003. Thanks! Example: Quicksilver Oil Company Well Name Data Data Data .01 .01 .01 .02 .02 .02 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
External Data Import | Excel Discussion (Misc queries) | |||
external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
Import External Data - XML | Excel Discussion (Misc queries) | |||
Using external data with differing formats in a spreadsheet | Excel Discussion (Misc queries) | |||
import external data | Excel Discussion (Misc queries) |