at work we have problem like this too, the different
is that we have both sql server and oracle running and
the data could be for either database, which the
syntex can be different.
the good thing about speadsheet (Like excel) is that
we can change data there very very quickly.
so using excel as central point what we have done is
to create a macro to create the insert script, another
copy and paste on to a new work sheet.
as long as the sum of length of each table does not
exceed 65535 rows, then you have yourself a copy and
paste script to put to query analyser or sqlplus (via
text file).
JL
--- John Sorkin <[log in to unmask]> wrote:
> Madan,
> You might be able to load data directly into a table
> using the software supplied with your SQL engine. I
> use Microsoft SQL server. The Enterprise Manger
> allows me to load data directly from an Excel
> spreadseet.
> John
>
> John Sorkin M.D., Ph.D.
> Chief, Biostatistics and Informatics
> Baltimore VA Medical Center GRECC and
> University of Maryland School of Medicine Claude
> Pepper OAIC
>
> University of Maryland School of Medicine
> Division of Gerontology
> Baltimore VA Medical Center
> 10 North Greene Street
> GRECC (BT/18/GR)
> Baltimore, MD 21201-1524
>
> 410-605-7119
> NOTE NEW EMAIL ADDRESS:
> [log in to unmask]
>
> >>> Madan Kundu <[log in to unmask]> 12/28/05
> 2:30 PM >>>
> Hi,
>
> I have one question regarding SQL. Suppose I have
> made an table in SQL using CREATE TABLE command. Now
> if I want to enter the record then I have to use
> INSERT INTO .... VALUES ..... If I want to enter
> 1000 records then I have to write INSERT INTO ....
> VALUES ..... 1000 times. No doubt this is a boring
> process. Is there any shortcut.
>
> Any suggestion in this regard will be appreciated.
>
> With regards,
>
> Madan
>
>
> --------------
>
>
> Madan Gopal Kundu
> Room no 18, Sukhatme Hostel
> Indian Agricultural Statistics Research Institute
> Library Avenue, Pusa
> New Delhi 12
> India
> Web: http://www.freewebs.com/madanstata
> mobile: 91-9868788406
> e-mail: [log in to unmask]
>
>
>
>
>
>
>
> Send instant messages to your online friends
> http://in.messenger.yahoo.com
>
___________________________________________________________
Yahoo! Exclusive Xmas Game, help Santa with his celebrity party - http://santas-christmas-party.yahoo.net/
|