Re: Bulk Insert with no Delimeter

#1

Hi

You only problem seems to be that OEM should be in quotes!

Try:

bulk insert test from 'D:\temp\test.txt'
with (codepage='OEM')

John

"BlckHlDev" <blckhldev (AT) rediffmail (DOT) com> wrote

Quote:

Is it possible to use Bulk Insert from a .txt which does not have any
field
delimeter but having \n as RowTerminator?

Tried with CodePage e.g.
bulk insert test from 'D:\temp\test.txt'
with (codepage=OEM)
(or ACP,Raw etc.)

but reporting
"Incorrect syntax near 'OEM'"

How to solve this Problem?

TIA
BlackHole

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Bulk Insert with no Delimeter

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Re: Bulk Insert with no Delimeter - 08-23-2003 , 09:03 AM