AnsweredAssumed Answered

Trying to import excel data to populate a new database

Question asked by MichaelKaufman on Jul 22, 2011
Latest reply on Jul 26, 2011 by MichaelKaufman

Title

Trying to import excel data to populate a new database

Post

Lets say I have a database with the following structure:

Table A             Table B          Table C

--------             --------         ---------

_pkA                 _pkB             _pkC

A1                    B1                _fkA

A2                    B2                _FKB

                                           C1

                                           C2

I also have a series of Excel Files of the form:

B1 B2 A1 A2 C1 C2

B1 B2 A1 A2 C1 C2

B1 B2 A1 A2 C1 C2

Is there a simple way to populate the tables?  I suppose I could import all of the data into a new table and populate the other tables manually, but it seems like a lot of work for a script that is only going to be run once. 

Any suggestions would be apreciated.  Thanks.

Outcomes