February 21, 2008 at 8:57 am
Hello All,
I have several text files and want to insert to our database. What is the best way to bulk insert to SQL?
I have a sample text file below.
Thank in advance for your helps
0220
08
Department of Agriculture
Farm Service Agency
Aerial Photography Field Office
84119-2020
T
541922
Department of Agriculture, Farm Service Agency, Aerial Photography Field Office, 2222 West 2300 South, Salt Lake City, UT, 84119-2020, UNITED STATES
T--Photographic, mapping, printing, & publication services
(RFI)USDA-RFI-Resource-2008
031408
03292008
Charlotte Vanderbilt, Contract Specialist, Phone 801-844-2914, Fax 801-956-3640, Email charlotte.vanderbilt@slc.usda.gov - John Mootz, Contract Specialist, Phone (801) 844-2916, Fax (801) 956-3640, Email john.mootz@slc.usda.gov
A. DIGITAL RESOURCE ACQUISITION
The U.S. Department of Agriculture, Farm Service Agency (FSA), Aerial Photography Field Office (APFO), in preparation and planning for an apparent transition from aerial film to direct digital acquisition for natural resource aerial photography projects, is requesting information related to price factors.
http://www.fbo.gov/spg/USDA/FSA/APFO/(RFI)USDA-RFI-Resource-2008/listing.html
Link to FedBizOpps document.
0220
08
Department of the Air Force
Air Force Materiel Command
ESC - Electronic Systems Center
01731
70
501 East Moore Drive R-1155 MAFB-Gunter Annex, AL
70 -- RADIANTONE VDS SOFTWARE MAINTENANCE
08-0007
marylou Cannon marylou.cannon@gunter.af.mil
NOTICE OF INTENT TO AWARD SOLE SOURCE. Contracting Office: Department of the Air Force, Air Force Material Command, Electronic Systems Center, HQ 754TH Electronic Systems Group, 501 East Moore Dr., Room 1155, MAFB-Gunter Annex AL 36114-3000 Notice:
http://www.fbo.gov/spg/USAF/AFMC/ESC/08-0007/listing.html
RADIANTONE VDS SOFTWARE MAINTENANCE on HERBB
E-mail the POC
0220
08
Department of the Interior
U. S. Geological Survey
U. S. Geological Survey
20192
89
U S GEOLOGICAL SURVEY, APS TEAM C, EASTERN REGION ACQUISITION AND GRANTS BRANCH NATIONAL CENTER, MS 152 RESTON VA 20192
89--Specific-Pathogen-Free Embryonated Chicken Eggs
08ER29-NoSolicitation
022508
02192009
CHRISTY DONAHUE CONTRACTING OFFICER 7036487389 ;
The U.S. Geological Survey, BRD, National Wildlife Health Center, Madison, WI has a requirement to obtain specific-pathogen-free (SPF) embryonated chicken eggs.
http://www.fbo.gov/spg/DOI/USGS/USGS/08ER29-NoSolicitation/listing.html
Please click here to view more details.
Point of Contact above, or if none listed, contact the IDEAS EC HELP DESK for assistance
Total Small Business
USA
500038154
Adel, IA
0220
08
Department of the Interior
U. S. Geological Survey
U. S. Geological Survey
20192
R
U S GEOLOGICAL SURVEY, APS ACQUISITION BRANCH, MS 205 12201 SUNRISE VALLEY DRIVE RESTON VA 20192
R--R--Professional Services/Systems Engineering
08HQSS0025
031008
02192009
KAREN PHILLIPS CONTRACT SPECIALIST 7036487393 kphillip@usgs.gov;
The U.S. Geological Survey (USGS), Reston, VA, has a requirement for scientific and engineering analyses to support the USGS responsibility for satellite spacecraft and ground systems. The USGS must be provided with timely, objective and non-advocacy input to plan, execute and evaluate system procurements and operational satellite anomalies.
http://www.fbo.gov/spg/DOI/USGS/USGS/08HQSS0025/listing.html
Please click here to view more details.
Point of Contact above, or if none listed, contact the IDEAS EC HELP DESK for assistance
N/A
USA
20192
EROS Data Center, Sioux Falls, SD
0220
08
Department of the Interior
Bureau of Reclamation
Bureau of Reclamation
80225
W
Bureau of Reclamation - GP-3800 316 N 26th Street, Rm 2031 Billings MT 59101
W--Rental Mobile Filter Press with Operator(s).
08SQ600114
022908
02192009
Vaschelle LaForge Contracting Officer 4062477812 vlaforge@gp.usbr.gov;
The principle components of the work include the following: Rental of mobile filter press with operator(s), with installed filter cloths, mobilization/demobilization, assistance with set up and decontamination of equipment. The work is located at the Leadville Mine Drainage Tunnel water treatment plant in Leadville, Colorado in Lake County The Request For Quotation (RFQ) package will be available on or around February 27, 2007, and offers are tentatively due in the office of the Bureau of Reclamation, 316 North 26th Street, Billings MT 59101 on or before Close of Business (COB) March 5, 2008.
http://www.fbo.gov/spg/DOI/BR/BR/08SQ600114/listing.html
Please click here to view more details.
Point of Contact above, or if none listed, contact the IDEAS EC HELP DESK for assistance
Total Small Business
US
80461
Leadville Mine Drainage Tunnel 749 Hwy 91 North Leadville, Colorado
0220
08
Agency for International Development
Overseas Missions
Georgia USAID-Tbilisi
20521-3180
R
541990
Agency for International Development, Overseas Missions, Georgia USAID-Tbilisi, Dept. of State, Washington, DC, 20521-3180, UNITED STATES
R -- Health Specialist - Avian Influenza Program
112-08-005
030708
03222008
Eka Kirvalidze, HR Specialist, Phone 995 32 922844, ext. 105, Fax 995 32 00 10 13, Email ekirvalidze@usaid.gov - Eka Kirvalidze, HR Specialist, Phone 995 32 922844, ext. 105, Fax 995 32 00 10 13, Email ekirvalidze@usaid.gov
The incumbent will be a member of the Health Team in the USAID/Baku Office. The Health Team is responsible for the management of the health portfolio for USAID/Caucasus -Azerbaijan.
http://www.fbo.gov/spg/AID/OM/TIB/112-08-005/listing.html
Link to FedBizOpps document.
AZERBAIJAN
USAID/Caucasus, Azerbaijan, #96, Nizami Street.
0220
08
Department of Health and Human Services
Substance Abuse and Mental Health Services Administration
Choke Cherry
20857
R
541690
Department of Health and Human Services, Substance Abuse and Mental Health Services Administration, Choke Cherry, 1 Choke Cherry Road Room 7-1051, Rockville, MD, 20857, UNITED STATES
R -- Program and Administrative Support for DPTSSP and OPPB
280-08-0212
040708
04222008
Linda Tillery, Contract Specialist, Phone 240-276-1513, Fax 240-276-1510, Email linda.tillery@samhsa.hhs.gov - James Whitt, Contracting Officer, Phone 240-276-1503, Fax 240-276-1510, Email james.whitt@samhsa.hhs.gov
The Substance Abuse and Mental Health Services Administration (SAMHSA)is soliciting proposals on an 8(a)competitive basis to provide program and administrative support to the Division of Prevention,Traumatic Stress, and Special Programs(DPTSSP) and the Office of Policy, Planning and Budget(OPPB).The DPTSSP oversees the Center for Mental Health Services(CMHS)youth violence prevention initiatives; youth suicide prevention initiatives, projects related to the prevention of mental and behavioral disorders,and the promotion of mental health;child trauma initiatives;disaster mental health initiatives;and a range of activities on both national and international levels.
http://www.fbo.gov/spg/HHS/SAMHSA/ChokeCherry/280-08-0212/listing.html
Link to FedBizOpps document.
0220
08
Department of Health and Human Services
Substance Abuse and Mental Health Services Administration
Choke Cherry
20857
R
541690
Department of Health and Human Services, Substance Abuse and Mental Health Services Administration, Choke Cherry, 1 Choke Cherry Road Room 7-1051, Rockville, MD, 20857, UNITED STATES
R -- Coordinated Technical Assistance Project on Emergencies and Disasters
280-08-0213
040708
04222008
Linda Tillery, Contract Specialist, Phone 240-276-1513, Fax 240-276-1510, Email linda.tillery@samhsa.hhs.gov - James Whitt, Contracting Officer, Phone 240-276-1503, Fax 240-276-1510, Email james.whitt@samhsa.hhs.gov
The Substance Abuse and Mental Health Services Administration (SAMHSA)is soliciting proposals on an 8(a)competitive basis to maintain the SAMHSA Disaster Technical Assistance Center (DTAC) and provide assistance to States and communities to prepare for, respond to and recover from disasters and terrorist events and to develop a coordinated infrastructure for mental health and substance abuse service needs consistent with evolving healthcare and preparedness systems and requirements.
http://www.fbo.gov/spg/HHS/SAMHSA/ChokeCherry/280-08-0213/listing.html
Link to FedBizOpps document.
February 21, 2008 at 9:25 am
February 21, 2008 at 9:34 am
Hi carolyn,
I just upload the text file.
Thank you for the quick respond
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply