copy table to hard drive

[iroosma]

I have created a table in access and now I want to copy that table to the C drive as an individual DBF file. I am using visual basic in access and I can not figure out how to do this. Any help will be greatly appreciated.

Thanks

 

[PHV]

Have you tried something like this ?
DoCmd.RunSQL "SELECT * FROM newTable INSERT INTO dbfTable IN 'C:\path\to\dbfdir' '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