 | |
creating tables info. please
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: creating tables info. please -
01-08-2008
, 06:43 AM
|
Hi Charles these methods seem very powerful, but i m not sure i know how to do them, but i think i am using something 95% similar to the second methos you talked about, the 'macro' one. i just wrote a VBA, with an insert into formula in Excel, so i generate the data in excel, i save the rows in a txt file and from there i do a crete table in oracle, and i paste the values i have in the txt so the thing i am copying and pasting is kind of this: creat table_XXX( sal_x varchar2(12), sal_prod ........) insert into table table_xxx value(....,....,...); ............ ........ commit; thats how i know to do it at the present time, but since you have something better, i would like you to show me some info. on any valuable documentations about it. Thanks a lot. |
it looks like in your example you are storing numbers as text. Don't do
that.
Jim
#12
| |||
| |||
|
|
Hi Charles these methods seem very powerful, but i m not sure i know how to do them, but i think i am using something 95% similar to the second methos you talked about, the 'macro' one. i just wrote a VBA, with an insert into formula in Excel, so i generate the data in excel, i save the rows in a txt file and from there i do a crete table in oracle, and i paste the values i have in the txt so the thing i am copying and pasting is kind of this: creat table_XXX( sal_x varchar2(12), sal_prod ........) insert into table table_xxx value(....,....,...); ............ ........ commit; thats how i know to do it at the present time, but since you have something better, i would like you to show me some info. on any valuable documentations about it. Thanks a lot. |
it looks like in your example you are storing numbers as text. Don't do
that.
Jim
#13
| |||
| |||
|
|
Hi Charles these methods seem very powerful, but i m not sure i know how to do them, but i think i am using something 95% similar to the second methos you talked about, the 'macro' one. i just wrote a VBA, with an insert into formula in Excel, so i generate the data in excel, i save the rows in a txt file and from there i do a crete table in oracle, and i paste the values i have in the txt so the thing i am copying and pasting is kind of this: creat table_XXX( sal_x varchar2(12), sal_prod ........) insert into table table_xxx value(....,....,...); ............ ........ commit; thats how i know to do it at the present time, but since you have something better, i would like you to show me some info. on any valuable documentations about it. Thanks a lot. |
it looks like in your example you are storing numbers as text. Don't do
that.
Jim
#14
| |||
| |||
|
|
Hi Charles these methods seem very powerful, but i m not sure i know how to do them, but i think i am using something 95% similar to the second methos you talked about, the 'macro' one. i just wrote a VBA, with an insert into formula in Excel, so i generate the data in excel, i save the rows in a txt file and from there i do a crete table in oracle, and i paste the values i have in the txt so the thing i am copying and pasting is kind of this: *creat table_XXX( sal_x varchar2(12), sal_prod ........) insert into table table_xxx value(....,....,...); ............ ........ commit; thats how i know to do it at the present time, but since you have something better, i would like you to show me some info. on any valuable documentations about it. Thanks a lot. |
http://groups.google.com/group/comp....e96fd1ed209ba3
The Excel method example actually performs a select from the database,
but it could just as easily perform an insert into a table. By
default, ADO in Excel will perform a commit after each insert
statement.
Other members of the group posted additional methods for accomplishing
the task.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
#15
| |||
| |||
|
|
Hi Charles these methods seem very powerful, but i m not sure i know how to do them, but i think i am using something 95% similar to the second methos you talked about, the 'macro' one. i just wrote a VBA, with an insert into formula in Excel, so i generate the data in excel, i save the rows in a txt file and from there i do a crete table in oracle, and i paste the values i have in the txt so the thing i am copying and pasting is kind of this: *creat table_XXX( sal_x varchar2(12), sal_prod ........) insert into table table_xxx value(....,....,...); ............ ........ commit; thats how i know to do it at the present time, but since you have something better, i would like you to show me some info. on any valuable documentations about it. Thanks a lot. |
http://groups.google.com/group/comp....e96fd1ed209ba3
The Excel method example actually performs a select from the database,
but it could just as easily perform an insert into a table. By
default, ADO in Excel will perform a commit after each insert
statement.
Other members of the group posted additional methods for accomplishing
the task.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
#16
| |||
| |||
|
|
Hi Charles these methods seem very powerful, but i m not sure i know how to do them, but i think i am using something 95% similar to the second methos you talked about, the 'macro' one. i just wrote a VBA, with an insert into formula in Excel, so i generate the data in excel, i save the rows in a txt file and from there i do a crete table in oracle, and i paste the values i have in the txt so the thing i am copying and pasting is kind of this: *creat table_XXX( sal_x varchar2(12), sal_prod ........) insert into table table_xxx value(....,....,...); ............ ........ commit; thats how i know to do it at the present time, but since you have something better, i would like you to show me some info. on any valuable documentations about it. Thanks a lot. |
http://groups.google.com/group/comp....e96fd1ed209ba3
The Excel method example actually performs a select from the database,
but it could just as easily perform an insert into a table. By
default, ADO in Excel will perform a commit after each insert
statement.
Other members of the group posted additional methods for accomplishing
the task.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
#17
| |||
| |||
|
|
Hi Charles these methods seem very powerful, but i m not sure i know how to do them, but i think i am using something 95% similar to the second methos you talked about, the 'macro' one. i just wrote a VBA, with an insert into formula in Excel, so i generate the data in excel, i save the rows in a txt file and from there i do a crete table in oracle, and i paste the values i have in the txt so the thing i am copying and pasting is kind of this: *creat table_XXX( sal_x varchar2(12), sal_prod ........) insert into table table_xxx value(....,....,...); ............ ........ commit; thats how i know to do it at the present time, but since you have something better, i would like you to show me some info. on any valuable documentations about it. Thanks a lot. |
http://groups.google.com/group/comp....e96fd1ed209ba3
The Excel method example actually performs a select from the database,
but it could just as easily perform an insert into a table. By
default, ADO in Excel will perform a commit after each insert
statement.
Other members of the group posted additional methods for accomplishing
the task.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.