Linker IT Software
Google
Web www.oraxcel.com
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
Save insert statements (Read 2284 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Save insert statements
08.08.06 at 11:36:53
 
Save insert statements
 
Brian from the USA asked the following question.
 
Question:
I was wondering if there was a way to save a particular insert statement so if I decided that I needed to run it again, it would be more readilyavailable to me.  To key in the column names is quite cumbersome and would be using the same format each time I wanted to populate data into the table from the spreadsheet.  
 
What we are trying to do is utilize your tool to take data from thousands of spreadsheets and populate them into a table.  We are trying to find the easiest way to do this.  Let me know if there are any ways to make this easier.  
 
Answer:
If you are loading soo much data you probably use the multiple rows insert feature.
If you want to rerun the process your best option is to record a macro and rerunning that. With a little effort you can modify the macro to make it work with any amount of data.
http://www.oraxcel.com/projects/sqlxl/help/techniques/bulk_insert.htm
 
When you use the single row insert statement function in SQL*XL you can simply save the insert form and reuse it at any time.  
http://www.oraxcel.com/projects/sqlxl/help/dialogs/insert_single/index.html
 
When you decided to generate the insert statements in the spreadsheet I don't think you have problems. With the SQL*XL function SQLCreateInsertStatement you can make insert statement in cells. Just select all the insert statements to run them in the SQL dialog. Set the source in the SQL dialog to worksheet...
http://www.oraxcel.com/projects/sqlxl/help/functions/sqlcreateinsertstatement.ht ml
 
If you have special requirements, please explain your problem in a little more detail please.
Back to top
 
 

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