quote:

---

Originally posted by ocean

Hi there,

Im trying yo import some data .txt. The data that I have it comes without delimiters, so I need to use a Bulk in order to import my data, to my new table in the specify columns.

Data:

s 12 d3 Robert 121212 010062010 Paterson Ln43r UK (...)

The total is 15 columns.

I had create my table with 15 columns (dbo.RD)
The database called (ABC)
Path is C:\Data\Myfile.txt

And the code that im using is the following:


[ ABC.[dbo.RD_Construction]
from \\ C:\Data\WAST01.txt

[with(
[[,] codepage = {'raw'}]
[[,] datafiletype = {'native'}]
[[,] fieldterminator = ' ']
[[,] firstrow = 1]
[[,] formatfile = 'format_file_path']
[[,] keepidentity ]
[[,] keepnulls ]
[[,] maxerrors = 500 ]
[[,] rows_per_batch = >0]
[[,] rowterminator = 'row_terminator']
[[,] tablock ]
)]


Is not working

Any idea or any different way to import my data in SQL organizing it in 15 columns?

Thanks

---

Bulk Insert ABC.[dbo.RD_Construction]
from  "C:\Data\WAST01.txt"
with( datafiletype = 'char',
      fieldterminator = ' ' 
      rowterminator = '\n'  )

Bulk Insert ABC.[dbo.RD_Construction]
from  "C:\Data\WAST01.txt"
with( datafiletype = 'char',
      fieldterminator = ' ' 
      rowterminator = '\n'  )

quote:

---

Originally posted by ocean

Try this

Bulk Insert ABC.[dbo.RD_Construction]
from  "C:\Data\WAST01.txt"
with( datafiletype = 'char',
      fieldterminator = ' ' 
      rowterminator = '\n'  )

---

Problem with brackets .Now try this.

Bulk Insert ABC.dbo.RD_Construction
from  "C:\Data\WAST01.txt"
with( datafiletype = 'char',
      fieldterminator = ' ' 
      rowterminator = '\n'  )

quote:

---

Originally posted by ocean

Problem with brackets .Now try this.

Bulk Insert ABC.dbo.RD_Construction
from "C:\Data\WAST01.txt"
with( datafiletype = 'char',
fieldterminator = ' '
rowterminator = '\n' )
---------------------------------------------------------------------------

msg 4861, level 16, state 1, line 3
"the system cannot find the path specified" is the second time that happens to me using two different queries.

Im really lost here, thanks

---

Tell Me few question :
1 .where have you placed the file means what is the location of file
Is it remote server or local server.
2

quote:

---

Originally posted by ocean

But I can use a local too...

---

Try doing this on your Local marchin.

Create simple table on your local system . And import the file from your local system like from C:\data\yourFIle.txt.

So you will get to know how it works