Query Problem

[Swi]

I have the following query:

SELECT * INTO [Excel 8.0;Database=T:\NAF-INPUT.XLS].[Sheet1] FROM [GREENBAR.DBF] WHERE PID = '7014280' OR PID = '7171535' OR PID = '7355771' OR PID = '7944731' OR PID = '8014909' OR PID = '8021885' OR PID = '8025759' OR PID = '8025771' OR PID = '8035844' OR PID = '8070586' ORDER BY PID

It gives me the error 'Query input must contain at least one table or query'

Any ideas?

Swi

 

[PWise]

GREENBAR.DBF

what type of table is this a local access table ,linked table,or a dbase table

 

[Swi]

DBASE table.

Swi

 

[PWise]

try

SELECT * INTO Sheet1  
in '' [Excel 8.0;Database=T:\NAF-INPUT.XLS]
FROM  GREENBAR IN 'filepath' [dBase IV;]

 

[PHV]

Why not simply use linked tables ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Swi]

I will give both suggestions are try.

Swi