openquery "select into"

[oakpark5]

OK, here we go again with these darn linked servers...
I'm trying to copy data from foxpro table into a sql table using linked servers. I keep on getting error 7321: an error occurred while preparing a query for execution against OLE DB provider MSDASQL. This is the code i used. I cant find my way around this error and I cant find a solution...thanks in advance.

select * from OPENQUERY(K_AR,'select arcust01.* INTO CUSTOMERS IN kretekrdb.mdb from arcust01')

Software Engineer
Team Lead
damn bill gates, he has everything

 

[JohnDTampaBay]

How about this?

SELECT *
INTO Customers
FROM OPENQUERY(K_AR,'SELECT arcust01.* IN kretekrdb.mdb FROM arcust01')

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)