importr csv into excel template

S

smerten

Hello,

I have some data (contents of some tables) from a Oracle database a
csv list and would like to inport the data into a predefined exce
sheet (template).

The sheet contains a structure of tables and the data from csv shoul
be imported into these tables.

Is it possible to import csv lists into excel and to define
identifier for every single csv data of a table?
Something like an identifier which could be mapped to a identifie
defined within the excel sheet.

Sorry I'm a newbie but maybe you have some hints.
Thankx,
Sve
 
D

Dave Peterson

If you were doing in manually, could you open the .csv file, then copy column by
column to a different worksheet?

If yes, then you could record a macro when you did it once (and the generalize
that code).

If this isn't even close, you may want to post a little snippet of your .csv
file (and the mapping rules). (Don't post a workbook--just the text data.)
 
Top