Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
complex insert scenarios (Read 2519 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
complex insert scenarios
06.04.06 at 11:12:41
Adam from the UK asked the following question.
We are migrating a lot of Excel data in the dB but we need to duplicate certain information from the spreadsheet into multiple tables at once. How to best do this?
You could decide to let SQL*XL pump it all into a reception table. So you have more control over the transactions you could use SQL or PL/SQL if you use Oracle or T-SQL if you use SQL Server to process the data further.
You use the SQL*XL multiple rows insert feature to insert the data into your reception table:
Back to top

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1