I used the code that was provided, and appreciate it. Now is there a way to change the file name to be imported?

I.E.

from \\servername\folder\sample.txt
then import a new file
from \\servername\folder\sample2.txt

Again this was very easy to implement and now need it to change file names.

While it may have not been the best solution, I did find one. Thank you all.

hi i have the same problem with my unl files. what do you mean by unicode data types? isit changing my data types of my fields to nchar?
how should i go about it. i receive the same prompt error when i use bulk insert.

thnx for advise!

Girl,

How about posting the error that you see at your end, here?

_________________________
- Vijay G
Strive for Perfection

i have my data something in this form.

aa|0|abcdefg|
b|0|abcdefg|

i use this method in my query analyser

BULK INSERT adl_ntid from 'C:/abc.unl with
(

FIELDTERMINATOR = '|',
ROWTERMINATOR = '|\n'
)

but they prompt me

Bulk insert data conversion error (truncation) for row 1, column 3 (NAME).