See, thats the problem. I am using Access for the first time. I have never
done any sort of database work (audio engineer) and as one of my co-workers
has developed the schema for this Oracle database, I am just in charge of
populating it.

When you say link a table to each of the sheets, what do you mean? I have
figured out how to export the Oracle schema into both Access and Excel
worksheets, but I do not understand "linking them."

Here is a very rough idea of what I imagine the macro will resemble:

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

Begin Loop
In worksheet A
Variable A = Current Row, Cell in Column A
Variable B = Current Row, Cell in Column B

For Worksheet B, C, D, E, F
Row in Current Worksheet = 1

Begin Loop

If Cell in Column A of Current Row in Current Worksheet = Variable A
Replace Cell in Column B of Current Row with Variable B
Next Row until End of File
End Loop

Next Row in Worksheet A until End of File

End Loop

I hope this clarifies my problem and not convolutes it.




"Patrick Molloy" wrote:

if you use MS Access, this becomes trivial. open a new Access database, link
a table to each of the sheets, open a query, add all the sheets & seelct
everything, using the GUID as the key for all sheets. The resultant results
can be resaved as a table and then you can suck it straight into your main
database.



"Emoshag" wrote:

Hello,

I am building an Oracle database and I am going to be using Excel to injest
the data. I am trying to give unique values to records and to do so I have
been hand copying rows between different worksheets and pasting the same GUID
(unique identifier) on matching column values between different worksheets.

I am desparately trying to find a time saving function or macro because this
task is taking way too long now that I am getting +50,000 records.

Is there a way to create a unique ID for a cell and then copy and paste
that ID into a cell in a specific row on another worksheet where a cell in
the target row is identical to a cell from the row where the ID is being
copied from?

I am desparate at this point, so if anyone has any ideas or needs more
information, I would be more thatn happy to provide it.