Can I import a dbf file using the IN clause of the Select statement

[rambleon]

I'd like to know if I can import a .DBF file into an Access table using the IN clause of the SELECT statement, if
so how?
Do I need a Data Definition File? What's its format? How do I use?

Thanks for any help

Rambleon

 

[PHV]

From the Jet SQL help file:

... FROM Table IN "" [dBASE IV; DATABASE=C:\DBASE\DATA\SALES;];

... FROM Table IN "C:\DBASE\DATA\SALES" "dBASE IV;"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244