importr csv into excel template

  • Thread starter Thread starter smerten
  • Start date Start date
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
 
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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top