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
|