Thanks for your support stewartc-708166.

Actually, the Distributed Queries has been set to be true both on my work server and remote server before I run the query.

exec sp_configure 'show...

Basically, there is no CSV file, my original file is Excel. Bacause BCP doesn't work on Excel, I convert my Excel file to CSV. Now I found the Excel can...

Hmmm... RPC and RPC OUT have been set true.I think there are something wrong with the ole db provider. Because other linked server can work fine....I have set the ole...

Sure

I only use the openrowset (the query is something like below) to create the table for excel.

Thanks

Lindsay

SELECT * INTO Test.dbo.sheet2 FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=\\localhost\TestExcel.xlsx', [Sheet1$])

Thanks for your post stewartc:)

Actually, I can use same user run the query on that remote server directly. But if I run the query via "EXECUTE (query) At rmlinkedserver", it...

I have found the way to use openrowset. Thanks a lot:)

Thanks

Lindsay

I have found another to create the table for excel. This thread can be closed:)

Thanks

Ling

Thanks for your response opc.three:)

The link is useful, but I saw it only have the sample to fromat a table/view in the database into the .fmt file, is there any...

Thanks a lot GSquared.

Do you mean that we should use the openrowset with excel provider? Could you please give me a sample? Thanks a lot:)

Thanks

Lindsay

Thanks a lot CEWII. Seems that I have to give us this way to import data from Excel. I will see other way to import data for it. Thanks a...

OK, I found that we can use DTEXEC with SSIS package command line to import data. Thanks every body:)

Thanks

Lindsay

Yes, Seems that SSIS and ADO can work on...

Thanks for your response The Dixie Flatline.

I know SSIS will be good tool to do it, but seems that we have to create a package and then run it. I...

Thanks for your quick response runaldo^_^

Basically, I know how to create package or import excel data via import export wizard. I'm seeking a way to import data via command line....

Thanks a lot Uripedes and Jeffrey.

Basically, I need to compare the data from the remote server, and all the data should located on that server, but I have to save...