Thanks..

I am using BULK INSERT in that i had specified ROW TERMINATOR & FIELD TERMINATOR only.

How to specify a TextQualifier?

I had used format file also.

Thanks

test1 contains

100 Alex

101 John

102 Gavin

103 Ashih

tes2 contains

100,101,102

I need to select names from test1 based on id available in tes2 (id in test1 is FK to test2)

Same way it stored in single column only

Hi I had used the query

select * INTO EMP_TABLE from OpenRowset('MSDASQL',

'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\Temp;Extended properties=''ColNameHeader=True;Format=pipeDelimited;''','select * from junk.txt')

But each row is stored in one column only.

I am using...

Thanks for ur reply..

You had changed 1,2,14,37,44 as 1,2,3,4,5

But it is host file field order only.

I have to specify sequence order? Because

i am selecting 1,2,14,37,44 filed from table (file) and...

Thanks

Hi How the format file would be for above ?

Where i have to specify source column name destn column name?

There is no IDENTITY column in below table..

Just i am doing select one value using SELECT and hardcode two values during insertion.. The above scenario works in normal INSERT &...

Thanks for ur reply..

I had changed the query as follows

INSERT INTO TEST1[ID,NAME,EMAIL]

SELECT A.ID,'Alex','alex@gmail.com'

FROM TEST2

RIGHT OUTER JOIN TEST2 B ON A.ID=B.ID WHERE A.ID IS NULL

now also it shows bellow error..

While executing...

Thanks for the query.

In my table two rows are missing, first row it shows 0 and next as 51.

51 is corect output before that 49 is missing.

It wont show 49..

Thanks steve

It works..

I had changed as follows..

Insert into [TEST1].[dbo].EMPLOYEE

Select *

From [TEST].[dbo].[EMP]

Hi

It shows invalid object name

TEST1.EMPLOYEE

Hi..

How to use this OPENQUERY without registering linked server?

Hi..

How to do SELECT * INTO..

Because i don't want to create the table..

I tried in below way

SELECT * INTO XLImport55 FROM OPENROWSET ('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=D:\Test\;', 'SELECT *...

Thanks... Can you give me the provider name..

with complete script

Thanks... Can you give me the provider name..

with complete script