|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Lose your application development headaches. Start developing and deploying applications with Advantage Database Server today. Download a 30-day trial for Free!
|
|
#1
October 8th, 2003, 10:10 PM
|
|||
|
|||
load data infile
how can i use load data infile to do the following
data file has 5 fields: a,b,c,,e table has 4 columns table colums = (a,b,c,e) load data infile 'file.txt' into table 'this_table' (a,b,c,,e) will not work ? is it posable to make it work ? I want to skip the empty column in the text file. On a Linux box.... Note: bcp is a microsoft program and will not run on Linux. Last edited by deterset : November 4th, 2003 at 09:39 AM.
|
|
#2
October 9th, 2003, 01:34 PM
|
||||
|
||||
|
You can use bcp to import the data and specify to skip a column by using a format file. See http://msdn.microsoft.com/library/d...cp_bcp_61et.asp for the bcp utiltity. At the bottom of the page is a link that tells you how to make/use format files. Hope this helps
__________________
Up the Irons What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home. "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest Down with Sharon Osbourne Puzzle of the Month solved by sizeablegrin, etienne141 and L7Sqr, superior C/C++ programmers of the month
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > load data infile |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
 |
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
